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

186 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
dahlia103577(None) 
dahlias1135721dahlias
dahl87019222dahl__
dahls95012282dahl_s
daphnia1345052daphnia
daylit10512492daylit
dulia61014982d_ulia
pallia83015592pallia
aalii5316133_aalii
abelia83114403abelia
abulia83512503abulia
acholia1239973acholia
aecia73819283_aecia
agria65517143_agria
aha611246643_ah__a
ahi68040233_ah_i_
ahis76135383_ah_is
ala312463603_a_l_a
alba68328333_a_lba
alfa77624273_a_lfa
alga57927603_a_lga
alias55834603_a_lias
alif76242143_a_lif
alit46155693_a_lit
aliya83713483_a_liya
alma66333023_a_lma
amia66836903_a_mia
amnia75918643_amnia
aphelia1249423aphelia
aria46245423_a_ria
atria56022343_atria
aulic74420243_aulic
baalim1038473baalim
bailie83818363bailie
balsa77920413ba_lsa
calif104929103ca_lif
calix145317353ca_lix
calla74827073ca_lla
cambia124913153cambia
camelia11510433camelia
caplin103216303caplin
cardia9916373cardia
carlin84421823carlin
cassia83714763cassia
catlin83819083catlin
caulis85320083caulis
challa114014193challa
chia96026623_ch_ia
cilia73016763_cilia
dacha114812573da_cha
dacoit9415453dacoit
dada66422443da__da
dagga839543da_gga
dagoba1074943dagoba
dah78148983dah___
dahabiah1742863dahabiah
dahabiya1741513dahabiya
dahoon1039053dahoon
dahs88231813dah__s
dailies84219263dailies
daily95922333dail_y
daimio937463daimio
dais57040703da__is
dakoit11310353dakoit
dal47554953da_l__
dale55643983da_l_e
dales66439743da_les
dalles74222063dalles
dallied93713613dallied
dallier84215373dallier
dallies84023193dallies
dally95324743da_lly
dals57145123da_l_s
dammit11311133dammit
danio6319783da_nio
daphnias1444683daphnias
daric85623113da_ric
darkie113714013darkie
darling93418363darling
dashi95013113dashi_
dashis104414393dashis
dassie74615573dassie
data56026653da__ta
datcha1266563datcha
datura738023datura
dautie72914703dautie
davit93424593da_vit
dawtie103011093dawtie
daylily1434983daylily
deflea1037443deflea
deli55631293d_eli_
delis64928543d_elis
delta66117773d_elta
dhal86719283dhal__
dhals95415443dhal_s
dharma1276103dharma
dharna1055263dharna
dobla84913643dobl_a
dolma86214173d_olma
doolie73916833doolie
doula65717773doul_a
dulias71212743d_ulias
dunlin739723dunlin
fabliau1244903fabliau
facia103218463fa_cia
fascia1148703fascia
folia83618933_folia
gala55635163ga_l_a
galea64722933ga_lea
gallic9411643gallic
gallica1047463gallica
gambia115912253gambia
ganglia946613ganglia
garlic9310043garlic
gaslit7513503gaslit
glia56423153__glia
haha107821063hah__a
halid94424983ha_lid
halloa94918123halloa
halma108219253ha_lma
halva115414433ha_lva
hila76228353__hila
ilia46026823__ilia
kahuna1394103kahuna
kalian10312163ka_lian
kalif125021363ka_lif
kalmia1238893kalmia
kalpa114512193ka_lpa
kaolin1039583kaolin
khalif1657833khalif
khalifa1742883khalifa
labia75219013la_bia
lamia75324323la_mia
latria62313593latria
maffia14327203maffia
mafia104418033ma_fia
mahonia1238443mahonia
malic94525663ma_lic
mania75634153ma_nia
manila84518303manila
maria75032883ma_ria
marlin84220903marlin
milia72719573_milia
nala46930393na_l_a
obelia8329453obelia
ohia75719363_oh_ia
paella8410913paella
palea75028663pa_lea
pallial92911253pallial
pallid93915283pallid
parhelia1346713parhelia
paulin8312983paulin
qualia1559563qualia
raffia12287703raffia
raia46638383ra__ia
raphia113511263raphia
ratlin64116523ratlin
realia6314593realia
sahib10314763sah_ib
salic73424713sa_lic
salina64221123sa_lina
saliva93110743sa_liva
salpa75018353sa_lpa
salsa56718923sa_lsa
salvia93310753salvia
scholia1237833scholia
sharia93116733sharia
tabla73318363tabl_a
taenia6313193taenia
taffia12286903taffia
tafia84215493ta_fia
tahsil936343tahsil
tala45938053ta_l_a
tali46837163ta_li_
tallis63319963tallis
tallit63422733tallit
tarsia65514273tarsia
telia55821143_telia
thulia936113thulia
valid94618393va_lid
varia85824203va_ria
vedalia1145683veda_lia
walla85321033wa_lla
wallie93216803wallie
yautia937253yautia
zamia165115213za_mia

Search took 6 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.1401276364.3
2DLD Change Limit1127161865.03022408.7
3Display Results1861860.0503720.0
 (SQL Overall)1786911865.22034232.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.