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

340 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
daedal84908(None) 
dedal75719021d_edal
caecal103713732caecal
caudal91611482caudal
credal9311672credal
dada66422442da_da_
dadas75819862da_das
deal56347412d_e_al
decal85523232d_ecal
faecal11359812faecal
hadal95518122ha_dal
haemal113811642haemal
medal86221332_medal
pedal86022502_pedal
sandal73317282sandal
vandal103713832vandal
aal39058673_a__al
acaudal1045783acaudal
acetal84314903acetal
adagial946373adagial
adaxial1545323adaxial
addax1435993_addax
adenyl1035023adenyl
adnexal1543823adnexal
adrenal838263adrenal
aecial84817313_aecial
aedes64625153_aedes
aedile73716653_aedile
aerial64625713_aerial
aldol61212333_aldol
algal66518223_algal
anal48037523_a_nal
annal56520763_annal
anodal72512123anodal
apodal9289833apodal
appal95315223_appal
areal55928733_areal
argal65023393_argal
artal55525473_artal
arval86017013_arval
audad71511393_audad
audial7312993_audial
aural54428963_aural
axal116520493_a_xal
axial124515193_axial
baal67033113ba__al
banal75925993ba_nal
banda85223103banda_
bandas95120543bandas
barbal104016663barbal
basal75722283ba_sal
bedel84219403_bedel
bipedal1245683bipedal
bridal9511453bridal
cabal95222153ca_bal
caeca93915133caeca_
caesar8410933caesar
calendal1145383calendal
cameral11311283cameral
canal75428043ca_nal
cantal84122033cantal
carnal83919213carnal
carpal103716253carpal
casual81112863casual
caudad10157673caudad
causal81413203causal
cecal94619113_cecal
cedar84014323_cedar
chaetal1238283chaetal
coaeval1245183coaeval
coeval1138893coeval
creedal1037093creedal
dacha114812573dacha_
dachas124113253dachas
dactyl1234983dactyl
dad58456163da_d__
daddle94214283daddle
daddy116212563da_ddy
dado67126333da_d_o
dados75522433da_dos
dads67442773da_d_s
daedalean1151563daedalean
daedalian1143353daedalian
daemon9279593daemon
dagga839543dagga_
daggas937973daggas
dahl87019223da__hl
dal47554953___dal
daledh1133743daled_h
daledhs1232783daledhs
daman84821163da_man
damar84117743da_mar
dammar11438903dammar
damsel9148033damsel
dander811222993dander
dandily12279633dandily
dandle84218093dandle
dandy104416703dand_y
darbar959953darbar
dared75935013dared__
dareful1157053dareful
daresay1135433daresay
darnel74312183darnel
data56026653da_ta_
dated75530993dated__
datedly1236023datedly
datival1135583datival
dawdle11399503dawdle
dawed106222813dawed__
dazed165919363dazed__
dazedly2134063dazedly
dead65434243d_e_ad
deaden83714323deaden
deader84220473deader
deadfall1343313deadfall
deadly113811473deadly
deadman11238423deadman
deadpan11225233deadpan
deads75726913dead_s
deaf85838403d_e_af
deals65435343d_e_als
dealt65234283d_e_alt
dean56039483d_e_an
dear55343603d_e_ar
deasil71110983deasil
debag94212303d_ebag
debar85517863d_ebar
decadal1137243decadal
decaf114919443d_ecaf
decals93717713d_ecals
decay114718483d_ecay
dedans85915073d_edans
deed65340903deed__
deeded94615543deeded
deeds75423763deed_s
deedy104315893deed_y
deejay1734523deejay
deewan10267553deewan
defat95426693d_efat
degas75119163d_egas
deil56231623d_e_il
del46752753d_e__l
delay94820633d_elay
dell56938203d_e_ll
denar65223293d_enar
denial74720513denial
dental74319173dental
deodar837713deodar
derail74218813d_erail
derat65044083d_erat
deray95024183d_eray
dermal93614343dermal
desalt7518313d_esalt
detail74516433d_etail
deva85720983d_eva_
devas96218883d_evas
devel94217123d_evel
devil94714733d_evil
dewan95718043d_ewan
dewar95817733d_ewar
dewax165510853d_ewax
dhal86719283d__hal
dial55935063d__ial
died66137853died__
diel59034603die__l
diesel74410403diesel
dihedral1344433dihedral
dismal92412243dismal
distal73615773distal
djebel1643453djebel
domal85619203d_omal
doodad936423doodad
dorsal74613943dorsal
dossal75510303dossal
dotal64919623d_otal
dread74419023dre_ad
dreads84115023dreads
dream85120393dre_am
drear65016903dre_ar
dredge9308563dredge
dreidel934473dreidel
dreidl835233dreidl
dual55928173d__ual
ducal84816423d_ucal
ductal938993ductal
duel56729703due__l
dural64923893d_ural
dwell9519853dwe_ll
dyed96720763dyed__
egal55119433__egal
facial113615633facial
faena85014203faena_
faenas94412763faenas
fallal93612693fallal
fardel104712593fardel
farfal123410183farfal
fatal84819373fa_tal
faucal11339963faucal
faunal94711593faunal
feal713940423_fe_al
fecal105119213_fecal
feral85424653_feral
fetal85623373_fetal
feudal1037683feudal
foetal9311883foetal
gaed66031513gaed__
gametal1037603gametal
garda7316763garda_
gardai839663gardai
gavial10310083gavial
gayal9312713ga_yal
gaydar1135503gaydar
haed86338583haed__
halal85623593ha_lal
hallal94415563hallal
hamal104623113ha_mal
hammal134512063hammal
handax1749583handax
hartal9415473hartal
heal75645693_he_al
hemal104419803_hemal
hiemal11339503hiemal
hyetal1236543hyetal
ideal65716393ide_al
ileal56118083ile_al
jacal14313703ja_cal
jackal1937613jackal
kheda1346533kheda_
khedah1743643khedah
khedas1446313khedas
labial84714343labial
laical8312323laical
landau7310613landau
larval948503larval
lateral7313573lateral
leal46043273_le_al
legal65715943_legal
lienal63912783lienal
madam10316223ma_dam
maenad939413maenad
mammal95112753mammal
mandala10310213mandala
manual8313463manual
mayday1535883mayday
meal65643173_me_al
meatal84114733meatal
medals94218053_medals
medial93819863_medial
metal75427383_metal
modal85919243_modal
nada58022903na_da_
nadas66320813na_das
narial6317953narial
narwal938943narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
nidal65217103_nidal
nodal64717793_nodal
ordeal779253ordeal
paean77222723pae_an
paella8410913paella
paesan85114093paesan
paleal84716673paleal
palpal104112053palpal
paludal1035683paludal
panda85022613panda_
pandas95521963pandas
papal95820673pa_pal
pardah123412823pardah
parral85517533parral
pascal10812373pascal
pausal81511963pausal
payday1536613payday
peal68648103_pe_al
pedalo93811153_pedalo
pedals94316033_pedals
penal75228373_penal
petal76526893_petal
plexal1536843plexal
praedial1178763praedial
predial103815413predial
quezal2435143quezal
racial83419243racial
radar61316723ra_dar
radial74020393radial
ramal74622243ra_mal
randan7315253randan
rascal8511123rascal
ratal55025113ra_tal
real45750293_re_al
redan66125013_redan
redial74923113_redial
regal65023793_regal
renal55929503_renal
sabal75422483sa_bal
sacral83414413sacral
salal55425703sa_lal
sambal105215183sambal
sandals82715203sandals
sardar73013173sardar
scandal1038673scandal
seal45654373_se_al
sedan65620423_sedan
sendal73314993sendal
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
sheal84927703she_al
steal56125473ste_al
tael46030713tae__l
tamal73522623ta_mal
tapetal938273tapetal
tarnal63716503tarnal
tarsal63315273tarsal
teal45546503_te_al
tepal76319583_tepal
thecal113310303thecal
thenal92712423thenal
tidal64516443_tidal
ureal56722683ure_al
uredial82910483uredial
uveal84411073uve_al
vagal94613633va_gal
valval12398863valval
vanda94515923vanda_
vandals113211663vandals
vandas103915993vandas
vasal85516293va_sal
vassal979243vassal
veal76936813_ve_al
venal85523213_venal
wadmal1237283wadmal
waeful1238123waeful
weal75838683_we_al
wedel94513963_wedel
wheal115716183whe_al
zeal135530333_ze_al
zoeal144813783zoe_al

Search took 7 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.403443402.0
2DLD Change Limit1127163405.61020092.0
3Display Results3403400.0933655.9
 (SQL Overall)1786913406.10629264.8
 
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.