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 “elevations” 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.

130 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
elevations133863(None) 
elevation1239231elevation_
clavations1546182clavations
delegations1348032delegations
elations83719122el__ations
elections112414972ele_ctions
elevating1338202elevati_ng
elevators1246302elevat_ors
eluviations14115792eluviations
enervations1478572enervations
lavations1238972_lavations
legations102711922_legations
relegations1248972relegations
aerations9317903_aerations
alations82518893al__ations
alienations1147883alienations
allegations1246043allegations
alleviations1554503alleviations
alterations11511663alterations
bevatrons1443713_bevatrons
bloviations1643753bloviations
celebrations1645743celebrations
chelations1539083chelations
clavation1447003clavation_
creations112614543cre_ations
cremations14410713cremations
crenations12511693crenations
deaerations12311673deaerations
defecations1779003defecations
delations102616593_delations
delectations1547453delectations
delegation1238883delegation_
deletions102610933dele__tions
denegations1348543denegations
denervations1657093denervations
derivations15611493derivations
deviations14311163_deviations
devotions1356593_devotions
educations1339233educations
egestions1046703ege_stions
ejections18249963eje_ctions
elation73620453el__ation_
election102015353ele_ction_
electrons112411763ele_ctrons
elevateds13122883elevat_eds
elevates111110423elevat__es
elevator1146713elevat_o_r
elevons1067573elev___ons
elocutions1245963elocutions
elongations1244663elongations
elutions82513053el__utions
eluviation1376613eluviation_
emanations1289593emanations
emendations1446053emendations
emulations12310943emulations
enations83316903__enations
enervation1369473enervation_
epilations12311713epilations
equations1839493e_quations
erections112515213ere_ctions
estivations1449273estivations
evasions1136543__evasions
evections142510693eve_ctions
evocations15259873evocations
excavations2345083excavations
execrations2048923execrations
executions1946393executions
exemptions2164833exemptions
exertions1639763exe_rtions
expiations1959663expiations
exudations18107073exudations
exuviations2195693exuviations
federations1548883federations
fellations1338063fel_lations
fetations12511383_fetations
flections14239213fle_ctions
flotations1366873flotations
gelations102513093_gelations
generations12311423generations
gleizations21135283gleizations
hebetations1656463hebetations
ideations1039903ide_ations
illations9311393il_lations
iterations10413823iterations
lavation1139973_lavation_
laxations1637623_laxations
lections102413843_le_ctions
legation92412933_legation_
lenitions939473_lenitions
levators11249283_levat_ors
levigations1546213_levigations
levitations1448293_levitations
libations112510443_libations
ligations102111993_ligations
lobations11219613_lobations
locations112512743_locations
lunations9310723_lunations
luxations1637273_luxations
negations102811963_negations
nervations1359483nervations
novations12139003_novations
operations12312953operations
ovations11149263__ovations
peltations12311553pel_tations
placations1438583placations
planations1238723planations
plications14310493plications
predations13812153predations
privations15310103privations
relations92418333_relations
relaxations1845643relaxations
relegation11610023relegation_
relocations13311143relocations
renovations1448423renovations
reservations1588583reservations
revelations14410303revelations
salivations1448733salivations
salvations1338133salvations
sedations10311253_sedations
selections12310873sele_ctions
solvations1336833solvations
televisions1452343televisions
tevatrons1244003_tevatrons
tolerations1158133tolerations
ulcerations1346363ulcerations
ululations1037143ululations
vegetations1547323vegetations
venations12311723_venations
venerations14411313venerations
vexations1937753_vexations

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031306.64021175.2
3Display Results1301300.0632063.5
 (SQL Overall)1786911307.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.