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

266 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
defleas114722(None) 
befleas1236971befleas
deflea1037441deflea_
beflea1147122beflea_
dealers84118612dealers
defeat103817162def_eat
defeats113511232def_eats
defers105116942def_ers
defiers113913992defiers
defies104624052defie_s
defilers12439472defilers
defiles114016842defile_s
defleaed1344952defleaed
deflect13399972deflect
deflects14336732deflects
defuels11296982defuels
delead84112342de_lead
deleads9379702de_leads
deles65139252de_le_s
deltas74414822de_ltas
dewless1137472dewless
fleas86423662__fleas
reflets103513152reflets
azaleas1636993azaleas
bedless1039703bedless
beefless1335493beefless
beflag1265883befl_ag
beflags1355493beflags
befleaed1454663befleaed
befleck1843943befleck
beflecks1943753beflecks
befrets1237613befrets
beleap10410283be_leap
beleaps1138053be_leaps
belgas9311713be_lgas
belles85325993belle_s
ceilers93912533ceilers
celebs1037883ce_lebs
dahlias1135723dahlias
dales66439743d_ale_s
dalles74222063dalle_s
deadens93410693deadens
deafens11317253deafens
deafness1236213deafness
dealer74122143deale_r
deals65435343deal__s
deaves105319533deave_s
debeak1336763de_beak
debeaks1436103de_beaks
debtless1135653debtless
debyes1238103debye_s
decease1049523de_cease
deciles104417723decile_s
deckels14367363deckels
deckers144413833deckers
deckles143312803deckle_s
declass1038733declass
declaw1266703decl_aw
declaws1336253declaws
decrease1136563decrease
decrees102513123decrees
deedless10318253deedless
deeds75423763de__eds
deems85421773de__ems
deepens10307813deepens
deeps84921773de__eps
deers64930523de__ers
dees56356633de__e_s
deets65330243de__ets
defacers14237993defacers
defaces133213403defaces
defamers14258523defamers
defames132812253defames
defangs1235363defangs
defat95426693def__at
defats105114553def_ats
defect124816173def_ect
defects134511523defects
defend113910493def_end
defends12358773defends
defense1137503def_ense
defer94619753def_e_r
deffer134411303deffe_r
deffest14308803deffest
defied115016383defie_d
defier105118653defie_r
defile105216663defile__
defiled124013103defile_d
defiler113911883defile_r
definers124211193definers
defines114118683defines
defis96717503def__is
deflate113613943deflate
deflaters13298703deflaters
deflates123013943deflates
defleaing1444743defleaing
deflexed2043883deflexed
deflowers16145643deflowers
defoam1238563def_oam
defoams1336193defoams
defocus1335283defocus
defogs1156683def_ogs
deforms1337803deforms
defrag1136463def_rag
defrags1236193defrags
defray1337643def_ray
defrays1436113defrays
defter104215923defte_r
deftest112611713deftest
deftness1236303deftness
defuel10348933defue_l
defunds12376753defunds
defusers12487363defusers
defuses114814593defuses
defuzes20398303defuzes
degas75119163de__gas
degrease1045413degrease
degrees92810723degrees
deicers103612733deicers
deices94119373deice_s
deifiers12348993deifiers
deifies113317453deifie_s
deils65722863deil__s
dekes105224453de_ke_s
delay94820633de_l_ay
delays104014053de_lays
dele56843083de_le__
deleave1147723de_leave
deleaves1248063de_leaves
deled75326543de_le_d
delete73620703de_lete
deletes83117933de_letes
delfs94918673de_l_fs
delfts10439673de_lfts
delis64928543de_l_is
dellies83622213dellies
dells66630943de_l_ls
dels56745473de_l__s
delta66117773de_lta_
delts65731793de_l_ts
delvers113411993delvers
delves104917083de_lves
demean9510563de_mean
demeans1039723de_means
demes86032693de_me_s
demies94825803demie_s
denes65639723de_ne_s
deniers84515183deniers
denies74729643denie_s
deplete103010423deplete
depletes112810643depletes
deploys1336523deploys
depress10239873depress
dermas94116813de_rmas
deters74724683de_ters
deuces94015513deuce_s
devas96218883de__vas
devels104313903de_vels
dewlap1264843dewl_ap
dewlaps1334663dewlaps
dexes135224513de_xe_s
dexies145018343dexie_s
dholes104914793dhole_s
dialers83614303dialers
differs14339973differs
doblas93812293dobl_as
doffers14359853doffers
doglegs1034783doglegs
doles67843753d_ole_s
dolmas95213043d_olmas
doolees83711613doolees
doulas75114993doul_as
doyleys14384923doyleys
duelers83412053duelers
duellers9268223duellers
duffels14296453duffels
duffers143410093duffers
duffles14308923duffle_s
dulias71212743d_ulias
dwellers12356083dwellers
ediles74016983edile_s
feelers103814743feelers
feeless103511103feeless
fellas95116963fe_llas
fellers104117543fellers
flea75628493__flea_
fleam106017283__fleam
fleams115011943__fleams
flees85828753__flees
flews115316443__flews
fleys117015603__fleys
galeas74618513_galeas
gelees74116263ge_lees
healers104319463healers
heelers103815623heelers
hefters134312003hefters
hellers103619833hellers
henleys1334843henleys
idealess935653idealess
jefes155613673jef_e_s
keglers12277773keglers
keleps12478813ke_leps
keyless1436163keyless
leafless11246573leafless
leaflets11244813leaflets
leas45954183___leas
legless838013legless
medleys13115333medleys
melees83618083me_lees
melenas999203me_lenas
merles85322763merle_s
mewlers12288983mewlers
netless739863netless
pedlers103013273pedlers
peelers93615593peelers
pegless1038053pegless
peles75738083pe_le_s
pellets94014783pellets
pleas75627033__pleas
queleas1636723queleas
reales64934123reale_s
reclean938523reclean
recleans1037513recleans
redlegs936823redlegs
reelers73520273reelers
refeeds11368973refeeds
refeels10379693refeels
refels94618053ref_els
refers93921083ref_ers
refiles104122423refile_s
reflag1098083refl_ag
reflags1156953reflags
reflect123913713reflect
reflects13288873reflects
reflet94024233refle_t
reflew12389453refle_w
reflex16359513refle_x
reflexes1865933reflexes
reflies104418533reflies
refloat10310833refloat
refloats1156913refloats
reflows13258983reflows
refuels10399523refuels
reglets83512983reglets
release7312763re_lease
relets64025673re_lets
replead10399013replead
repleads11357213repleads
riflers103512193riflers
rifles94217703rifle_s
sealers74323553sealers
selfless1135013selfless
sellers73721323sellers
selles64426983selle_s
selvas93812913se_lvas
sexless1467243sexless
teflons1036543teflons
telegas837443te_legas
teles54536003te_le_s
telfers10299073telfers
tellers73717603tellers
teslas64212173tesl_as
vealers103214293vealers
veilers103911823veilers
webless1237003webless
yellers103912953yellers

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.393454684.5
2DLD Change Limit1340272666.70020004.0
3Display Results2662660.0962770.8
 (SQL Overall)1786912667.18924856.2
 
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.