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

250 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
eluants73758(None) 
eluant6315091eluant_
eluents738701eluents
alants67722022al_ants
blunts84512892blu_nts
elands74914772el_ands
elans55527752el_an_s
elints65816422el_ints
eluate62315432elua_te
eluates72014682eluates
eluent6315482eluent_
errants7410642errants
flaunts1056132flaunts
gelants82611442gel_ants
gellants9308282gellants
levants1037722levants
lunts55826902_lu_nts
plants84921802pl_ants
quants153614142_quants
slants64819082sl_ants
truants738162truants
abluents1045463abluents
alands75418373al_ands
alans55636173al_an_s
alant55742293al_ant_
alkanes113812933alkanes
alkanets12366233alkanets
alumnus935223alumnus
ants47243473___ants
aunts55227633_au_nts
bezants1877343bezants
bezzants1843643bezzants
blanks124112893bl_anks
blasts85116773bl_asts
blats75132503bl_a_ts
bleats85518613blea_ts
bloats85215763bloa_ts
bluets87215493blu_ets
bluings10327963bluings
blunt75525023blu_nt_
blurts84412643blu_rts
brants85723053_brants
brunts85215453bru_nts
bunts75729803_bu_nts
byzants2153223byzants
callants104112143callants
cants77036943__cants
chants115020393_chants
chaunts1267083chaunts
clangs95113613cl_angs
clanks124615183cl_anks
clans75031013cl_an_s
clasts84817293cl_asts
cleans85817053clean_s
cleats84919313clea_ts
clients938093clients
clunks124811013clu_nks
counts84618273cou_nts
courants10310803courants
cunts76125123_cu_nts
daunts75014083dau_nts
debutants1243713debutants
decants103514443decants
descants112910143descants
deviants1236733deviants
diluents946053diluents
dopants1038433dopants
dunts65828413_du_nts
easts57530323e__asts
eats47054873e__a_ts
eclats8313033ecla_ts
educts9439893edu_cts
effluents15133443effluents
elains64919853el_ains
elan46734243el_an__
eland65820393el_an_d
elate55335883el_a_te
elates65032363el_ates
elects83315003el_ects
elegant8311503elegant_
elegits8149343elegits
elements10312173elements
elephants1444803elephants
elfins94810943elfin_s
elicits9311233elicits
elint55436473el_int_
eloins65419383eloin_s
eluders8409903eluders
eludes75417683elu_des
elute54822573elu__te
elutes64020313elu_tes
embanks15295703embanks
enacts84012973e_nacts
enchants1347833enchants
entrants8311753entrants
epacts105010393e_pacts
equals1538693equa_ls
equate152012463equa_te
equates162012323equates
equines161811593equines
errands847603errands
errant6618733errant_
eructs83610793eru_cts
erupts8348903eru_pts
etchants1346023etchants
ethanes103713513ethanes
evacuants1442953evacuants
events94814073e_vents
exacts15359613e_xacts
exalts13328313e_xalts
expands17195733expands
expats1537683expa_ts
explants1737023explants
extant132714753extant_
extents142610173extents
exults13257633exu_lts
flanes94522423fl_anes
flanks133913403fl_anks
flans85327973fl_an_s
flats86429743fl_a_ts
flaunt9712913flaunt_
flaunty1354413flaunty
flints95617453fl_ints
floats96816253floa_ts
fluent9313933fluent_
flunks13469863flu_nks
fluyts12367153flu_yts
founts94313383fou_nts
gallants93310373gallants
gelant72821673gel_ant_
gellant83214053gellant_
giants74713503_giants
glands85314403gl_ands
glans65125833gl_an_s
gleans75014743glean_s
glints75714213gl_ints
gloats74515423gloa_ts
glucans1045293glucan_s
gluons738503gluon_s
gluts66120133glu__ts
grants73722473_grants
grunts75511853gru_nts
guanos73811993_guanos
guans64419443_guan_s
hants86335403__hants
haunts95614393hau_nts
heliasts1136103heliasts
hunts86826173_hu_nts
iguanas835383iguanas
incants92012803incants
infants102210773infants
jaunts137511883jau_nts
jurants14379213jurants
lands65426903_l_ands
lanes54946793_l_anes
lasts57731263_l_asts
lats45962703_l_a_ts
lauans65113533lauan_s
leans55536253_lean_s
leant56737783_leant_
leasts64616413_leasts
lemans85316393leman_s
levant9314493levant_
lianas63713383_lianas
lianes63819323_lianes
liangs74410593_liangs
lints57137193_l_ints
llanos6108333_llanos
loans56026463_loan_s
luaus54514903_lua_us
lunars65012813_lunars
lunas55025013_lu_nas
lunate6316043_lunate
lunes55337773_lu_nes
lunets66914763_lunets
lungs65223883_lu_ngs
lunks94822453_lu_nks
lunt46148843_lu_nt_
lusts55022803_lu_sts
mediants11299493mediants
mounts84115073mou_nts
mutants938583mutants
octants9128733octants
pants76536923__pants
peasants1038263peasants
pedants10310113pedants
peltasts1035703peltasts
pendants1139093pendants
pennants1037063pennants
plaints94012053plaints
plaits83816473pl_aits
planes85028083pl_anes
planets93914083pl_anets
planks124116753pl_anks
plans75731273pl_an_s
plant75437113pl_ant_
plats75531373pl_a_ts
pleats85218593plea_ts
pliant83918823pliant_
plunks124711163plu_nks
punts75828003_pu_nts
quant143624813_quant_
quanta153911333_quanta
quarts154715933_quarts
quints154316563_quints
rants55935343__rants
recants93217093recants
recusants1145103recusants
regrants9310013regrants
relands85214883rel_ands
relaxants1643243relaxants
relents74018503rel_ents
reliant7319243reliant_
reloans7313133reloan_s
relucts9369673relu_cts
remnants1036843remnants
replants102811243replants
ruanas6311263_ruanas
runts55927633_ru_nts
savants1038653savants
scants85219723_scants
sealants82610743sealants
seawants11337973seawants
secants93413893secants
sequents1756993sequents
servants1138003servants
sextants15287383sextants
shunts95712023shu_nts
slangs75615343sl_angs
slant55238703sl_ant_
slanty95114843sl_anty
slats55436903sl_a_ts
sluts54523983slu__ts
sonants7511233sonants
squats153712963squa_ts
squints16339033squints
stunts65615253stu_nts
suints64617783_suints
taunts65715663tau_nts
tenants7311013tenants
truant6315783truant_
tyrants1037453tyrants
ulans54921303ul_an_s
ululant747693ululant_
valiants1137793valiants
vaunts95212623vau_nts
versants1137783versants
wants87932213__wants
yuans84613323_yuan_s
yulans958673yulan_s

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 Limit1340272506.98319193.3
3Display Results2502500.0803125.0
 (SQL Overall)1786912507.46923924.4
 
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.