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

243 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
datcha126656(None) 
dacha114812571da_cha
datchas1347421datchas
batch124620102batch_
cancha134411612cancha
catch125120372catch_
catchy16559582catchy
dachas124113252da_chas
data56026652dat__a
datura738022datura
ditch115015092ditch_
dutch114713822dutch_
gotcha1234632gotcha
hatch135719592hatch_
latch104620462latch_
match125621102match_
natch105018222natch_
pacha126518062pa_cha
patch125221222patch_
patchy16509572patchy
ratch104221362ratch_
watch135617062watch_
ache96829823_a_che
achy126316093_a_chy
acta69524803_a_cta
aecia73819283_aecia
agha87417303_a_gha
aha611246643_a__ha
aitch105216163aitch_
aloha8513613_aloha
alpha1049653_alpha
ancho104515303_ancho
arch98628443_arch_
atma68121773_at_ma
atria56022343_atria
bacca111012183ba_cca
bach116131393ba_ch_
barca91319433barc_a
barchan1469133barchan
batched154114243batched
batcher144414853batcher
batches144019613batches
bath95940083bat_h_
bathe105822883bat_he
baths105922923bat_hs
bitch125017763bitch_
bitchy16479203bitchy
botch126717453botch_
botchy16537823botchy
butch125416543butch_
caca85528083ca_c_a
cache125122483ca_che
caeca93915133caec_a
canchas143212403canchas
catchall1546233catchall
catcher143115823catcher
catches144320773catches
catchup1644793catchup
catclaw1443973catclaw
catechu1444473catechu
catena8312483catena
chatchka22202893chatchka
concha134213283concha
cratch134110793cratch_
cutch125116193cutch_
dace76934923da_c_e
daces85030683da_ces
dactyl1234983dactyl
dada66422443da__da
dagga839543da_gga
dagoba1074943dagoba
dah78148983da__h_
dahl87019223da__hl
dahlia1035773dahlia
dahs88231813da__hs
dance85223133danc_e
danced105315253danced
dancer94817613dancer
dances95120653dances
darshan1167063darshan
dash87031633da_sh_
dashi95013113da_shi
dashy125612383da_shy
datary10310243datary
date56443323dat__e
dated75530993dat_ed
dater65332313dat_er
daters74827373daters
dates65639153dat_es
dating85326483dating
datival1135583datival
dative10311813dative
dato56129943dat__o
datos65222783dat_os
datto65416423dat_to
dattos74311903dattos
datum8310633dat_um
datums936353datums
daturas838773daturas
death94822523deat_h_
deaths105914443deat_hs
deathy134210233deat_hy
detach12310413detach_
diarchy1644673diarchy
dicta84915633d_icta
dita56032523dit__a
ditched143711903ditched
ditcher134012003ditcher
ditches133215713ditches
doth86225713dot_h_
douche124613223douche
drachm1436493drachm
drachma1544303drachma
duchy144310873d_uchy
dunch115316263dunch_
dutchman1643013dutchman
dyarchy1942503dyarchy
each95530583ea_ch_
eath75735663eat_h_
etch95419143_etch_
facia103218463fa_cia
fascia1148703fascia
fatwa1168063fat_wa
fetch134913473fetch_
fitch134816873fitch_
fitchy17437623fitchy
gauche1238553gauche
gaucho1256223gaucho
gotchas1334613gotchas
haha107821063ha__ha
halacha15388003halacha
hatched163414463hatched
hatchel153510753hatchel
hatcher153314723hatcher
hatches153420273hatches
hatchet153317563hatchet
hatchway2243293hatchway
hath105933913hat_h_
hitch134515473hitch_
hotch136214723hotch_
hutch135414093hutch_
itch95619173_itch_
itchy13449013_itchy
kasha124710723ka_sha
kata85626023kat__a
katchina1745333katchina
katcina1345153katcina
ketch144912023ketch_
klatch15445933klatch_
kwacha1832983kwacha
laich105920713laich_
laichs115110893laichs
larch105919793larch_
latched133914063latched
latches123320123latches
latchet123117903latchet
lath76640383lat_h_
lathe85626713lat_he
lathi85417203lat_hi
laths86022403lat_hs
lathy115215063lat_hy
latina65621143latina
latria62313593latria
letch105215803letch_
litchi1137893litchi
macchia1645893macchia
mach116134473ma_ch_
mache125925303ma_che
macho126120153ma_cho
machs125722563ma_chs
maltha1137503maltha
manche133515103manche
march125622893march_
matched153513963matched
matcher143214283matcher
matches143219783matches
matchup1643513matchup
math95437443mat_h_
maths105624023mat_hs
matsah1138233matsah
matza16311813mat_za
matzah2035963matzah
mocha1249923_mocha
mutch125016173mutch_
nachas114914193na_chas
nacho105414383na_cho
nautch1144813nautch_
notch105613323notch_
nucha10229793_nucha
oath76132153oat_h_
oaths86117313oat_hs
paca85132243pa_c_a
pachas135017143pa_chas
pakeha1533933pakeha
panchax2134983panchax
panocha1444983panocha
parch125123003parch_
paschal14157243paschal
pasha105417183pa_sha
pataca10311193pataca
patched153514623patched
patcher143515143patcher
patches143320383patches
path99134913pat_h_
paths105521383pat_hs
patina86022193patina
pitch125018413pitch_
pitchy16479673pitchy
ranch105019793ranch_
rancho114310853rancho
ratches123620463ratches
ratchet124218333ratchet
rath76037663rat_h_
rathe85821923rat_he
retch104818303retch_
rotch105815933rotch_
rotche114311983rotche
sacra74516993sa_cra
sancta839833sancta
satara6315533satara
satchel123310303satchel
sauch104918773sauch_
sauchs115112233sauchs
slatch114510533slatch_
snatch114310603snatch_
snatchy15355293snatchy
swatch14549283swatch_
tach96132753ta_ch_
tache106222373ta_che
tachs105820933ta_chs
tetchy1436003tetchy
thatch1435613thatch_
thatchy1833303thatchy
vacua10510463va_cua
vetch134411843vetch_
watched163012823watched
watcher153113403watcher
watches153017373watches
watchman1844623watchman
waucht14399413waucht
witch134517563witch_
witchy17468593witchy
yacht13417393ya_cht

Search took 9 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.1431249587.4
2DLD Change Limit1127162438.68612976.7
3Display Results2432430.0803037.5
 (SQL Overall)1786912438.90920057.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.