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

123 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
evocations1525987(None) 
avocations15168681avocations
evocation142010291evocation_
revocations16410311revocations
vocations141911421_vocations
advocations1755412advocations
avocation14168992avocation_
educations1339232educations
elocutions1245962elocutions
evacuations1646302evacuations
evections142510692evec_tions
evictions14228622evic_tions
evocators1446712evocat_ors
evolutions13107042evolutions
invocations1647062invocations
locations112512742_locations
relocations13311142relocations
revocation15410812revocation_
vacations141910552_vacations
vocation132311982_vocation_
adorations11310233adorations
advocation1645743advocation_
allocations1347773allocations
aviations12311553av_iations
avocational1645183avocational
bilocations1545293bilocations
cations94524143___cations
coactions1349743_coactions
conations111318903_conations
convocations1947363convocations
decoctions1547143decoc_tions
decorations14312883decorations
dedications15310873dedications
defecations1779003defecations
denotations1239853denotations
derogations1349393derogations
desolations12310593desolations
detonations1239373detonations
deviations14311163dev_iations
devolutions15106263devolutions
devotions1356593devo__tions
donations101112353_donations
dotations101411633_dotations
education12310203education_
eductions1268773educ_tions
ejections18249963ejec_tions
elations83719123e__lations
elections112414973elec_tions
elevations1338633elevations
elocution1145673elocution_
elongations1244663elongations
emaciations1548163emaciations
emanations1289593emanations
embrocations1843983embrocations
emotions10610283emo__tions
emulations12310943emulations
enations83316903e__nations
epilations12311713epilations
equations1839493e_quations
equivocations2751843equivocations
erections112515213erec_tions
eructations1347233eructations
etiolations1147393etiolations
evacuation1547163evacuation_
evaluations1457323evaluations
evaporations1744693evaporations
evasions1136543ev__asions
evection131910833evec_tion_
eviction13228683evic_tion_
evocative1746293evocati_ve
evocator1346573evocat_o_r
evolution12117093evolution_
exactions1838923exac_tions
execrations2048923execrations
executions1946393executions
expiations1959663expiations
exudations18107073exudations
flotations1366873flotations
furcations1547533furcations
invocation1547543invocation_
iodations1039113_iodations
isolations10310693isolations
levigations1546213levigations
levitations1448293levitations
lobations11219613_lobations
location102113913_location_
locutions11207063_locutions
medications1649933medications
notations91512973_notations
novations12139003_novations
orations81515803__orations
ovations11149263__ovations
ovulations1337973ovulations
ozonations1945143ozonations
perorations13314063perorations
phonations1538313phonations
placations1438583placations
plications14310493plications
potations111615073_potations
proactions1449343proactions
probations14311083probations
pronations12314033pronations
prorations12314463prorations
provocations1956873provocations
quotations19146283quotations
relocation12312113relocation_
renovations1448423renovations
revelations14410303revelations
revolutions1497633revolutions
rogations101510823_rogations
rotations91613843_rotations
solations9814623_solations
sulcations1289583sulcations
vacation131911893_vacation_
venations12311723_venations
vernations13310333vernations
vexations1937753_vexations
violations1337963violations
vocational1546953_vocational
vocatives1745883_vocatives
volitions1288663_volitions
volutions12108393_volutions
zonations18139313_zonations

Search took 7 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.436409841.7
2DLD Change Limit1406031235.61025062.9
3Display Results1231230.0631952.4
 (SQL Overall)1786911236.10929250.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.