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

207 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
eclair83681(None) 
eclairs935961eclairs
chair105519632_chair
claim95616912_claim
declaim1247362declaim
eclat7523602ecla_t
eclats8313032eclats
elain55324702e_lain
exclaim1844942exclaim
flair86114122_flair
glair65313552_glair
lair45934152__lair
reclaim1137752reclaim
acari75020283ac_ari
acclaim1345783acclaim
affair1234353affair
air38058403___air
alar46340073_ala_r
alcaic1039983alcaic
beclamor1484303beclamor
beclasp1335263beclasp
bedchair1642793bedchair
blain75421793_blain
bolar75123473bola_r
caid77837543_c_aid
cain65643913_c_ain
caird85717233_c_aird
cairn75717513_c_airn
calif104929103_calif
calix145317353_calix
car59165563_c_a_r
carr65434703_c_arr
cedar84014323ceda_r
celiac101910433celiac
cellar84514983cellar
celli76717693celli_
chai95929903_chai_
chain105723673_chain
chairs114916183_chairs
chais107530313_chais
char95132153_cha_r
charr104821783_charr
choir105313603_choir
clach124617823_clach
clack134720173_clack
clad76225823_cla_d
clade85821013_clade
clads85722733_clads
clag75924573_cla_g
clags85621123_clags
claimer11279883_claimer
claims105211573_claims
clam86332293_cla_m
clamor1049453_clamor
clamp115517653_clamp
clams95127673_clams
clan65633923_cla_n
clang86019313_clang
clank114719523_clank
clans75031013_clans
clap86429043_cla_p
claps95626183_claps
clapt98027173_clapt
claro75018693_claro
clary105719613_clary
clash106219033_clash
clasp95517193_clasp
class75525483_class
clast76030583_clast
clave105420153_clave
claver113816973_claver
clavi104912923_clavi
clavier1239173_clavier
claw95624343_cla_w
clawer114512783_clawer
claws106020833_claws
clay95927413_cla_y
clayier1248323_clayier
clays105521333_clays
clear76219053_clear
clip86924003_cl_ip
clour76617283_clour
cochair1446313cochair
coir66327243_c_oir
czar156013133_cza_r
deair65817193_deair
declaimer1444233declaimer
declaims1345823declaims
declare10411233declare
declarer1148073declarer
declass1038733declass
declaw1266703decla_w
declaws1336253declaws
despair1045463despair
ear36867883e__a_r
ecesic10369223ecesic
ecesis84611203ecesis
echard1249223echard
echoer114011103echoer
echoic1339043echoic
ectasis9249613ectasis
ectatic11310123ectatic
eelier64216463eelier
eggar7458883egga_r
elains64919853e_lains
elan46734243e_la_n
eland65820393e_land
elans55527753e_lans
elapid939543e_lapid
elate55335883e_late
elater64724203e_later
elder64020023e_lder
elfin84312463e_lfin
elhi7612403e_lhi_
elixir1333703elixir
elmier839813e_lmier
eloin55923203e_loin
elver85216243e_lver
email74715103e_mail
embar94011603emba_r
emir65918703e__mir
enchain1248873enchain
enclasp1145843enclasp
enclave1257533enclave
enlace82213233enlace
entail61114343entail
eolian6312593eolian
escar74011993esca_r
eschar1136533escha_r
escolar946053escola_r
eskar9457453eska_r
euclase938933euclase
exclaimer2042843exclaimer
exclaims1943943exclaims
exclave1945193exclave
explain1667043explain
eyrir8359653e_yrir
fair76332523__fair
filar84819293fila_r
flail85316183_flail
flairs95711913_flairs
flir76422203_fl_ir
foliar93210973foliar
glaire74411303_glaire
glairs75211333_glairs
glairy10448273_glairy
gular6314833gula_r
hair76330143__hair
hilar85418143hila_r
impair1036003impair
inlaid7310143inlaid
laic65931563__laic
laid56439153__laid
lain46146283__lain
laird65417793__laird
lairs55425873__lairs
lar37967533__la_r
lari45839153__lari
liar47229693__liar
mair66133783__mair
malar76424443mala_r
medlar93010463medla_r
midair937993midair
mohair1135203mohair
molar75223093mola_r
mylar105311533myla_r
nectar838853necta_r
ocular8610133ocula_r
pair66031513__pair
palais8420423palais
peculiar1245453peculiar
pedlar93311273pedla_r
pilar75221503pila_r
plaid85118303_plaid
plain74823303_plain
plait75631573_plait
polar75623453pola_r
reclad9311873recla_d
reclads1049993reclads
reclaimer1344463reclaimer
reclaims1236113reclaims
reclame11411063reclame
reclasp1136643reclasp
relaid75518443relaid
repair84011463repair
scalar83612433scalar
scaler84321603scaler
scalier94316913scalier
scar66434203sc_a_r
scaur75814903sc_aur
sclaff1438313sclaff
secpar1037923secpa_r
secular92211533secula_r
slain54923573_slain
solar55927343sola_r
stair54719943_stair
talar56225383tala_r
tolar55524113tola_r
unchair1236163unchair
unfair936233unfair
unhair937333unhair
unlaid7311753unlaid
vair75624143__vair
velar85817633vela_r
volar86917413vola_r
wair75830053__wair
yclad11246383ycla_d

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162076.72016773.2
3Display Results2072070.0633285.7
 (SQL Overall)1786912077.17324911.6
 
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.