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

172 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
elisions8221042(None) 
elision72311101elision_
elusions82610081elusions
decisions1248382decisions
delusions1037052delusions
derisions1038842derisions
eclosions1146202eclosions
editions9310402editions
elations83719122elations
elusion72310952elusion_
elutions82513052elutions
emissions1146922emissions
envisions1245612envisions
erasions8310982erasions
erosions8310332erosions
evasions1136542evasions
excisions1846382excisions
lesions73813862_lesions
plosions1038022plosions
recisions1139912recisions
religions1086602religions
revisions1238592revisions
visions10311022_visions
alations82518893alations
allusions946003allusions
basions94213953_basions
benisons1037043benis_ons
billions102211783billions
bisons83914373_bis_ons
caissons1036283caissons
cessions1039853cessions
clarions10310493clarions
classons1037703classons
coitions10312843coitions
collisions1246323collisions
decision1148523decision_
delations102616593delations
deletions102610933deletions
delicious1246713delicious
delirious1045603delirious
delusion937433delusion_
demissions1345663demissions
derision939063derision_
divisions1396283divisions
eclosion1046893eclosion_
edition8310853edition_
effusions1544373effusions
eftsoons1142613eftsoons
egestions1046703egestions
eikons1038503e_i_kons
elains64919853el_ai_ns
elastins82111733elastins
elation73620453elation_
elections112414963elections
elevons1067573el_evons
elfins94810943el_fi_ns
elicitors1145803elicitors
elicits9311233elici_ts
eliding93414343elidi_ng
elitisms1048193elitisms
elitists848543elitists
elixirs1443543elixi_rs
eloigns8425353el_oigns
eloins65419383el_oi_ns
elution72913823elution_
elysian1065083elysian_
emersions1147283emersions
emission1047673emission_
emotions10610283emotions
emulsions1145343emulsions
enations83316903enations
ensigns836353e_nsigns
envision1145953envision_
eosins64419163e_osi_ns
epigons1048183epi_gons
epsilons1044223epsilons
erasion7311963erasion_
erosion7311103erosion_
essoins737603e_ssoins
etesians845473etesians
ethions1038483e_thions
evasion1036753evasion_
eversions1238363eversions
evictions14228623evictions
evulsions1254573evulsions
excision1746273excision_
exclusions1945013exclusions
eximious1743873eximious
explosions19134663explosions
fissions1138033fissions
flexions1844413flexions
fluxions1844423fluxions
foisons1047613fois_ons
frissons1145043frissons
fusions1039153_fusions
gelations102513093gelations
glistens9366593glistens
grisons838993gris_ons
helicons1337613heli_cons
helistops1444063helistops
hellions11310013hel_lions
illusions946213illusions
incisions1147353incisions
inions64417003__inions
jillions15178273jillions
kelsons1137323kel_s_ons
lections102413843lections
legions84611783_legions
lenitions939473lenitions
lesion64715063_lesion_
lessons73811013_lessons
lewissons1241743lewissons
liaisons844293_liaisons
linins65922143_lini_ns
lions55923213_l__ions
lipins85016883_lipi_ns
listens74014133_listens
logions86211293_logions
lotions74614763_lotions
lysins94610953_lysi_ns
malisons1048773malis_ons
mansions1069793mansions
millions101712423millions
minions93314623_minions
missions10311903missions
nasions73112383_nasions
nelsons738003nel_s_ons
oblivions1443243oblivions
omissions1146153omissions
opinions1045933opinions
orisons7310563oris_ons
passions10310583passions
pensions10311693pensions
petitions11511083petitions
pillions101610913pillions
pinions93413603_pinions
pistons93016373_pistons
plasmons12217663plasmons
plosion939113plosion_
poisons9310353pois_ons
precisions1449363precisions
prelusions1256373prelusions
previsions1547733previsions
prisons9313223pris_ons
pulsions1037713pulsions
raisins72715343raisi_ns
recision10310273recision_
reclusions1246243reclusions
relations92418333relations
relictions12310023relictions
religion996743religion_
religious1076033religious
remissions1246613remissions
revision1138713revision_
scissions1145423scissions
seclusions1244633seclusions
seditions1039013seditions
seisins73614393seisi_ns
sessions839713sessions
suasions838783suasions
televisions1452343televisions
telsons739203tel_s_ons
tensions8310223tensions
torsions839183torsions
tuitions838283tuitions
unisons748423unis_ons
venisons1136133venis_ons
versions11310353versions
virions1039873_virions
vision9311313_vision_
volitions1288663volitions
zillions17168063zillions

Search took 10 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.186960704.3
2DLD Change Limit1461621728.92316380.4
3Display Results1721720.0762263.2
 (SQL Overall)1786911729.18519454.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.