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 “deils” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

221 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
deils6572286(None) 
ceils75019401ceils
deals65435341deals
deil56231621deil_
delis64928541delis
dells66630941dells
dels56745471de_ls
devils104412811devils
heils85222191heils
veils84918801veils
ails45654712_ails
anils56326722anils
arils58732202arils
axils127217502axils
bails75933522bails
bells76432162bells
bels66142492be_ls
bezils1711310602bezils
boils75427192boils
ceil65725062ceil_
ceili75814792ceili
ceilis85413742ceilis
cells75428062cells
cels65534972ce_ls
coils75030082coils
dahls95012282dahls
daily95922332daily
dais57040702dai_s
dals57145122d_als
deads75726912deads
deairs74013782deairs
deal56347412deal_
dealt65234282dealt
deans66131392deans
dears65736882dears
debits94214502debits
debs76530242de_bs
debts86418372debts
decals93717712decals
decile94619212decile
deciles104417722deciles
decks124822192decks
decos85522122decos
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deets65330242deets
defies104624052defies
defile105216662defile
defiles114016842defiles
defis96717502defis
degas75119162degas
deice84320032deice
deices94119372deices
deify124112762deify
deign74312802deign
deigns8389982deigns
deism84116032deism
deisms94411042deisms
deist64633592deist
deists74916432deists
deity94316772deity
deixis1437242deixis
dekes105224452dekes
del46752752de_l_
dele56843082de_le
deles65139252deles
delf85436572de_lf
delfs94918672delfs
deli55631292de_li
delish105215612delish
delist74625052delist
dell56938202de_ll
delly96023872delly
delt57855272de_lt
delts65731792delts
demes86032692demes
demies94825802demies
demits94918072demits
demos86022992demos
denes65639722denes
denials84114132denials
denies74729642denies
denims95214322denims
dens55945072de_ns
dentils84115582dentils
dents65031802dents
derails84216392derails
derms85022892derms
desks105913072desks
details84214042details
devas96218882devas
devels104313902devels
devil94714732devil_
devs86424032de_vs
dewily1338342dewily
dews86230602de_ws
dexes135224512dexes
dexies145018342dexies
deys85027472de_ys
dhals95415442dhals
dials64925342dials
dibs76233682d_ibs
diel59034602diel_
dies55653522d_ies
diets66026642diets
difs86027322d_ifs
digs66036052d_igs
dill55239972d_ill
dills65530972dills
dims75435022d_ims
dins56652042d_ins
diols65521012diols
dips75536912d_ips
dirls64720502dirls
dis46459892d_i_s
diss56434482d_iss
dits56450522d_its
djins1368452djins
doily95321032doily
doits66223672doits
dolls66126922dolls
dols56943052d_ols
drails74716952drails
dreidls934052dreidls
dribs85115062dribs
dries64733672dries
drill64718262drill
drills74414202drills
drily95816522drily
drips85417232drips
duals65620082duals
duels65619232duels
duits65021882duits
dulls64523742dulls
dwells10417712dwells
edile64819492edile
ediles74016982ediles
edits65819032edits
eels46536742_eels
ells46431352_ells
els37645722_e_ls
evils84114262evils
fails85631482fails
feels85223042feels
fells85327382fells
fils75838692_fils
foils85025812foils
gels56836102ge_ls
hails85231642hails
heals85733452heals
heels85625532heels
heil76328932heil_
heirs85618562heirs
hells85032042hells
herls85226432herls
ideals75012502ideals
jails125422942jails
jells125522162jells
kails95525212kails
keels94622412keels
keirs95313672keirs
kevils13358332kevils
leis45739602lei_s
mails76037782mails
meals75933372meals
mells75031332mells
mels65941532me_ls
merls77423902merls
mewls105813232mewls
mils66045332_mils
moils76125752moils
nails55730402nails
neifs85613042neifs
nils46132452_nils
noils55024332noils
oils46337972_oils
pails75833062pails
peals75235492peals
peels75226422peels
peins76128062peins
perils84121852perils
rails55937402rails
reals55038652reals
reels55333262reels
reifs84819092reifs
reins56234562reins
reis45343232rei_s
reoils64516872reoils
riels55121332riels
roils54826792roils
sails55738102sails
seals54839692seals
seels55632822seels
seifs85019332seifs
seis45542392sei_s
sells55134432sells
sels46345982se_ls
soils55327982soils
speils84116222speils
tails55634192tails
teals56234132teals
teels55726372teels
tells55828942tells
tels46841692te_ls
tils45739612_tils
toils54527492toils
vails85825932vails
veals84926192veals
veil75523592veil_
veins84620492veins
vexils1647172vexils
wails86631482wails
weals85428742weals
weirs84316492weirs
wells85426192wells
yells85821942yells
zeals145320852zeals
zeins144715392zeins

Search took 5 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 Filter178691538000.1731032896.0
2DLD Change Limit538002214.34312387.8
3Display Results2212210.0633507.9
 (SQL Overall)1786912214.57939024.0
 
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.