Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “aurality” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
aurality113922(None) 
rurality1137401rurality
amorality1446722amorality
anality10313632a_nality
audacity1444822audacity
aurally10310542aural_ly
axiality1856762axiality
causality1445322causality
duality1147962du_ality
morality131110332morality
orality101111682_orality
plurality1444612plurality
quality1938562qu_ality
ruralite848962ruralite
uralite71714102_uralite
ability12311443a_bility
acridity1446913acridity
acrolith1348453acrolith
actuality1445803actuality
aerolite8315053aerolite
aerolith1149833aerolith
agility1148653a_gility
alkalify1842823alkalify
anility10312723a_nility
animality1447803animality
arability14411013a_rability
aridity11510113a_ridity
atonality1247073atonality
atrocity1347213atrocity
aural54428963aural___
auralities10410223auralities
aurate64426473aura__te
banality1338763banality
brutality1444123brutality
burlily1237713bur_lily
carnality1447593carnality
chirality1745453chirality
curability1747863curability
curlily1238383cur_lily
durability1647733durability
equality2046993equality
extrality1967203extrality
fatality1438443fatality
feracity1646733feracity
feudality1654393feudality
finality1448343finality
formality1746993formality
frailty1335663_frailty
frugality1653263frugality
fugacity1743313fugacity
furmity1535183fur_mity
futility1446973futility
garrulity1342593garrulity
gravity1437183_gravity
humanity1646313humanity
humility1646093humility
ideality1247153ideality
irreality1245413irreality
jurally1736963jural_ly
labiality1446363labiality
legality1237623legality
locality13148433locality
mammality1544283mammality
modality14117653modality
molality13118363molality
mortality1467733mortality
muralist10312983muralist
muralists1148163muralists
mutuality1444743mutuality
nasality1146653nasality
natality1139193natality
neutrality1345323neutrality
nodality12127423nodality
normality1447203normality
nubility1347783nubility
nullity1037363nu_llity
ovality1377593_ovality
penality13310713penality
puerility1445993puerility
purity114114913pur__ity
qualify2235473qu_alify
rarity93615493__rarity
rascality1445993rascality
reality10313573_reality
regality1249313regality
ruralise839643ruralise
ruralism1048533ruralism
ruralist8311703ruralist
ruralists947643ruralists
ruralites947943ruralites
ruralize1739233ruralize
rurally1038303rural_ly
sodality12127323sodality
spirality1446433spirality
suavity1336313su_avity
surlily10310003sur_lily
tonality1139793tonality
totality1139373totality
unreality1246323unreality
uralites82112723_uralites
uralitic10158453_uralitic
uranite72515693_uranite
urbanity13105303_urbanity
urolith1048783_urolith
utility1038703_utility
venality1438683venality
veracity1647553veracity
virility1447733virility
vitality1458113vitality
vocality16137933vocality
voracity1645533voracity

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621116.73321708.3
3Display Results1111110.0502220.0
 (SQL Overall)1786911117.20624797.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.