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

206 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
illations931139(None) 
illation8311941illation_
ablations11311512ablations
alations82518892_alations
ciliations121111002ciliations
collations12312852collations
delations102616592delations
dilations102614452dilations
elations83719122_elations
fellations1338062fellations
filiations13119092filiations
gelations102513092gelations
halations12312392halations
ideations1039902ideations
illatives1245522illatives
illusions946212illusions
inflations13310322inflations
iodations1039112iodations
isolations10310692isolations
lallations1038742lallations
libations112510442libations
ligations102111992ligations
oblations1139372oblations
relations92418332relations
siltations1038552siltations
solations9814622solations
ululations1037142ululations
vallations1339092vallations
violations1337962violations
ablation10312433ablation_
ablutions1146603ablutions
acylations1547603acylations
adnations1039753adnations
adulations11310123adulations
aerations9317903aerations
agnations10310033agnations
alation72920553_alation_
alkylations1843353alkylations
allantoins1083723allantoins
allegations1246043allegations
allocations1347773allocations
allusions946013allusions
alluvions1254373alluvions
aviations12311563aviations
bilections14136503bilections
billions102211793bill__ions
bilocations1545293bilocations
cations94524143__cations
chelations1539083chelations
ciliation111112493ciliation_
citations11312503citations
clarions10310493_clarions
clavations1546183clavations
collation11313993collation_
conations111318903conations
creations112614543creations
dealations11311373dealations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
dictations1389703dictations
dilatations1246413dilatations
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
elation73620453_elation_
elections112414973elections
elevations1338633elevations
elutions82513053_elutions
emulations12310943emulations
enations83316903_enations
epilations12311713epilations
equations1839493equations
etiolations1147393etiolations
fellation1238843fellation_
fellatios1245503fellatio_s
fetations12511383fetations
filiation121110243filiation_
filtrations1445623filtrations
fixations1936353fixations
flatirons1244483_flatirons
flections14239213flections
flotations1366873flotations
foliations1399943foliations
gelatins93414093gelati_ns
gelation93014433gelation_
gyrations1336923gyrations
halation11313853halation_
himations1438803himations
ideation9310493ideation_
ignitions1045803ignitions
illative1147183illati_ve
illusion846573illusion_
illuviations1553053illuviations
imitations1259963imitations
immolations1545473immolations
impactions1645413impactions
impatiens1345733impatiens
impletions1445003impletions
inactions1139323inactions
incautions1245973incautions
inflation12311093inflation_
inhalations14126743inhalations
insolations1149183insolations
insulations11310233insulations
invasions12115413invasions
iodation9310383iodation_
isatins7310773i_sati_ns
isolation9311643isolation_
iterations10413823iterations
jillions15178283jill__ions
kations114013663__kations
lallation939493lallation_
latinos73613803__latinos
lavations1238973lavations
laxations1637623laxations
lections102413843_lections
legations102711923legations
libation102411363libation_
librations12149063librations
ligation92313093ligation_
lineations1039543lineations
liquations1945623liquations
lobations11219613lobations
locations112512743locations
lotions74614763__lotions
lunations9310723lunations
luxations1637273luxations
malathions1543873malathions
migrations13168683migrations
millions101712433mill__ions
mutations111211453mutations
natations91412493natations
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidations1039213nidations
nitrations10312033nitrations
notations91512973notations
novations12139003novations
nutations91411763nutations
oblation1039863oblation_
olfactions1563873olfactions
orations81515803_orations
oscillations1445123oscillations
ovations11149263_ovations
ovulations1337973ovulations
palliations1347723palliations
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
pillions101610933pill__ions
pinnations1236883pinnations
pixilations2045333pixilations
placations1438583placations
planations1238723planations
platoons1038683_platoons
plications14310493plications
pollutions1245433pollutions
potations111615073potations
pulsations1236373pulsations
pupations1338123pupations
rations74123433__rations
reflations13311233reflations
relation82619773relation_
rogations101510823rogations
rotations91613843rotations
saltations10310623saltations
salvations1338133salvations
scalations1239783scalations
sedations10311253sedations
sibilations13127933sibilations
siltation939213siltation_
simulations1368393simulations
sinuations1039413sinuations
situations1038433situations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
spallations1356103spallations
stations82415223_stations
sublations12410113sublations
sudations1039903sudations
sulcations1289583sulcations
sulfations13107813sulfations
taxations1636863taxations
titillations1244443titillations
titrations1039173titrations
ululation938093ululation_
vacations141910553vacations
vacillations1744883vacillations
vallation1239753vallation_
valuations1348783valuations
venations12311723venations
vexations1937753vexations
vibrations15157373vibrations
villains1138013villa_i_ns
violation1238443violation_
vitiations1338743vitiations
vocations141911423vocations
volitions1288663volitions
volutions12108393volutions
zillions17168073zill__ions
zonations18139313zonations

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.470380193.6
2DLD Change Limit1486412066.43623095.2
3Display Results2062060.1101872.7
 (SQL Overall)1786912067.01625469.1
 
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.