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

183 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
eloigns842535(None) 
eloign7456981eloign_
eloins65419381eloi_ns
aligns75312952al_igns
aloins65022202aloi_ns
coigns94410062_coigns
elains64919852elai_ns
elfins94810942elfi_ns
eloigned1043422eloigned
eloigner943422eloigner
eloigners1042992eloigners
eloin55923202eloi_n_
ensigns836352ensigns
logins77820642_logins
loins56728422_loi_ns
algins74816433algi_ns
aliens65619213al_iens
align65016503al_ign_
aloin55227423aloi_n_
assigns836193assigns
bellings113811153bellings
belongs10408223belong_s
belons84119413belo__ns
beltings11369253beltings
blains84516373blai_ns
blogs85319233blo_g_s
blowguns1442163blowguns
bluings10327963bluings
boings96416873_boings
clings95716213cl_ings
clogs85519553clo_g_s
clonings11307443clonings
clons75228133clo__ns
closings11277673closings
cloughs13517053cloughs
clowns114810113clo_wns
coign85013913_coign_
coigne94612193_coigne
coignes103912153_coignes
coins75834553_coi_ns
colins85229043coli_ns
cosigns1047513cosigns
deigns8389983_deigns
deraigns1034883deraigns
designs9328313designs
doings84913183_doings
earings84517713earings
eatings84616443eatings
ebons74316093ebo__ns
eclosions1146203eclosions
edgings10256243edgings
egoisms1065953egoisms
egoists887073egoists
elain55324703elai_n_
elans55527753el__ans
elations83719123elations
elegies81312903elegies
elegits8149343elegits
elevens1066803elevens
elevons1067573elevons
elfin84312463elfi_n_
elides74420693el_ides
elint55436473el_i_nt
elints65816423el_ints
elisions82210423elisions
elites66027123el_ites
elodeas836963elodeas
eloigning1143453eloigning
eloined8149813eloined
eloiner7149183eloiner
eloiners8128153eloiners
eloining9310443eloining
elopers95112943elopers
elopes85918163elo_pes
eloping103512833eloping
elusions82610083elusions
elutions82513053elutions
emodins1039433emodins
emotions10610283emotions
endings92910443endings
enjoins1457333enjoi_ns
enoughs1144633enoughs
ensign737523ensign_
eolian6312593eolian_
eoliths10318573eoliths
eons46638713e_o__ns
eosins64419163e_osins
epigons1048183e_pigons
erlkings1333563erlkings
erosions8310343erosions
essoins737603essoi_ns
ethions1038483ethions
etoiles7411293etoiles
eulogias946553eulogias
eulogies938533eulogies
exogens1536883exogens
exons125813343exo__ns
feigns10407753_feigns
felons93615763felo__ns
feltings12317903feltings
flings106715283fl_ings
flogs95919963flo_g_s
flongs105010493flong_s
florigens13133863florigens
florins10311643florins
flyings14496063flyings
foins85523383_foi_ns
geldings11316163geldings
globins10278953globins
gloggs935033glo_ggs
goings84911523_goings
groins73917203groi_ns
hellions11310033hellions
helpings14255653helpings
heroins103518013heroi_ns
joins125818413_joi_ns
keloids1288663keloi_ds
kelvins14106563kelvi_ns
klongs11436603klong_s
laighs10508803_laighs
leggins9259473leggins
legions84611783legions
lesions73813873lesions
levins94514653levi_ns
liens56525503_l_iens
ligans76817733_l_igans
limns75718393_l_imns
lings67135773_l_ings
linns56123333_l_inns
lins47059063_l_i_ns
lions55923213_l_ions
loans56026463_lo_ans
lodens74315063_lodens
lodges86820153_lodges
logans76319063_logans
loges66534203_lo_ges
logics95711123_logics
login66025003_login_
logions86211293_logions
logons79818173_logons
logos67225333_lo_gos
logs57343113_lo_g_s
loids66220713_loi_ds
loin46838723_loi_n_
longans84510813_longans
longes75925573_longes
longs65527063_long_s
loons55731723_lo_ons
lorans65117603_lorans
losings82810623_losings
lotions74614763_lotions
loughs105014773_loughs
lowings113710073_lowings
lyings10488503_lyings
maligns1038133maligns
meloids10911453meloi_ds
melons84117713melo__ns
oleins6313523olei_ns
ologies8615023ologies
pelotons1038913pelotons
plains85019593plai_ns
plosions1038023plosions
ploughs13526103ploughs
quoins154110583quoi_ns
realigns936253realigns
recoins94019243recoi_ns
reigns74811753_reigns
rejoins143111383rejoi_ns
reloans7313133relo_ans
resigns83910963resigns
signs65516323__signs
sleighs11245673sleighs
slings74618013sl_ings
slogans8407983slogans
slogs64521843slo_g_s
sloids73712693sloi_ds
sloughs11497563sloughs
slovens10316573slovens
soigne74310033_soigne
solions7513753solions
welkins1437173welki_ns
weltings12388203weltings
yogins105114103_yogins

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271836.73319906.0
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.20224811.3
 
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.