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

193 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
iodations103911(None) 
iodation9310381iodation_
conations111318902conations
donations101112352donations
dotations101411632dotations
ideations1039902ideations
illations9311392illations
iodating1038822iodati_ng
iodinations1268842iodinations
isolations10310692isolations
lobations11219612lobations
locations112512742locations
nidations1039212nidations
notations91512972notations
novations12139002novations
orations81515802_orations
ovations11149262_ovations
potations111615072potations
rogations101510822rogations
rotations91613842rotations
sedations10311252sedations
solations9814622solations
sudations1039902sudations
violations1337962violations
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
adaptions1245223_adaptions
additions1186333additions
adnations1039753adnations
adoptions1245783adoptions
adorations11310233adorations
aerations9317903aerations
agnations10310033agnations
alations82518893_alations
auditions1078753auditions
aviations12311553aviations
avocations15168683avocations
bilocations1545293bilocations
bodacious1443993bodacious
cations94524143__cations
caudations13108223caudations
ciliations121111003ciliations
citations11312503citations
coactions1349743coactions
cognations1339593cognations
coitions10312853co_itions
collations12312853collations
conation101420883conation_
conditions13410103conditions
connations12312943connations
cooptions13107763cooptions
copatrons1346333copatrons
creations112614543creations
delations102616593delations
dictations1389703dictations
dilations102614453dilations
donation91513783donation_
dotation91412733dotation_
durations10311463durations
editions9310403_editions
elations83719123_elations
enations83316903_enations
equations1839493equations
etiolations1147393etiolations
evocations15259873evocations
exudations18107073exudations
fetations12511383fetations
filiations13119093filiations
fixations1936353fixations
flotations1366873flotations
foliations1399943foliations
formations1538203formations
foundations1543433foundations
gelations102513093gelations
gradations1286863gradations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
hydrations1745283hydrations
ideation9310493ideation_
ignitions1045803ignitions
illation8311943illation_
imitations1259963imitations
immolations1545473immolations
impactions1645413impactions
impatiens1345733impatiens
inactions1139323inactions
incautions1245973incautions
indagations1345403indagations
indamins1147603indami_ns
indentions1149063indentions
indexations1946023indexations
indications14310973indications
indictions1339313indictions
inductions1348803inductions
indurations1249583indurations
inflations13310323inflations
innovations1445263innovations
insolations1149183insolations
intonations1149523intonations
inundations12125533inundations
invasions12115413invasions
invocations1647063invocations
iodates8312903iodat__es
iodination1159983iodination_
iodins74216523iod__i_ns
ionizations2049893ionizations
isatins7310773i_sati_ns
isolation9311643isolation_
iterations10413823iterations
kations114013663__kations
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libations112510443libations
librations12149063librations
ligations102111993ligations
lineations1039543lineations
liquations1945623liquations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
mediations13310983mediations
migrations13168683migrations
moderations1448273moderations
modulations14147263modulations
monitions11310883monitions
motions94215003mo__tions
mutations111211453mutations
natations91412493natations
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidation9410583nidation_
nitrations10312033nitrations
nodulations12147003nodulations
nonactions1248373nonactions
notation81414603notation_
notions74014483no__tions
novation111710013novation_
nutations91411763nutations
oblations1139373oblations
options93810603_o_ptions
oration71617713_oration_
ovation101510023_ovation_
oxidations1845443oxidations
ozonations1945143ozonations
phonations1538313phonations
pinnations1236883pinnations
portions10514413po_rtions
positions11811503positions
potation101716783potation_
potions93417423po__tions
predations13812153predations
probations14311083probations
pronations12314033pronations
prorations12314463prorations
pupations1338123pupations
quotations19146283quotations
radiations11311923radiations
rations74123433__rations
redactions1359133redactions
relations92418333relations
rogation91612053rogation_
rotation81615453rotation_
sedation9312453sedation_
seditions1039013seditions
siltations1038553siltations
sinuations1039413sinuations
situations1038433situations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sorptions1137123sorptions
stations82415223_stations
sudation9310803sudation_
taxations1636863taxations
titrations1039173titrations
vacations141910553vacations
venations12311723venations
vexations1937753vexations
vibrations15157373vibrations
violation1238443violation_
vitiations1338743vitiations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
zonation171410723zonation_

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411937.29620372.9
3Display Results1931930.0932075.3
 (SQL Overall)1786911937.82922824.2
 
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.