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

213 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
datchas134742(None) 
dachas124113251da_chas
datcha1266561datcha_
batches144019612batches
canchas143212402canchas
catches144320772catches
dacha114812572da_cha_
daturas838782daturas
ditches133215712ditches
gotchas1334612gotchas
hatches153420272hatches
latches123320132latches
matches143219782matches
nachas114914192na_chas
pachas135017142pa_chas
patches143320382patches
ratches123620462ratches
watches153017372watches
aches106132293_a_ches
aghas97014873_a_ghas
aitches123014363aitches
alohas9411703_alohas
alphas1139513_alphas
anchos114214893_anchos
arches114822043_arches
atlas55821583_at_las
atmas75721013_at_mas
baches135426943ba_ches
barcas101016603barc_as
barchan1469133barchan
barchans1588683barchans
batch124620103batch__
batched154114243batched
batcher144414853batcher
batchers153613273batchers
bathes116524833bat_hes
bathos116215633bat_hos
baths105922923bat_h_s
bitches144117063bitches
botches143716023botches
butches144315363butches
cacas95627983ca_c_as
caches137926913ca_ches
cancha134411613cancha_
catch125120373catch__
catchall1546233catchall
catchalls1645493catchalls
catcher143115823catcher
catchers153114063catchers
catchup1644793catchup
catchups1744383catchups
catchy16559583catch_y
catclaw1443973catclaw
catclaws1543633catclaws
catechus1544823catechus
catenas9313113catenas
chatchkas23172783chatchkas
conchas144013313conchas
cratches153012543cratches
cutches143216463cutches
daces85030683da_c_es
dactyls1333913dactyls
dadas75819863da__das
daggas937973da_ggas
dagobas1145143dagobas
dahlias1135723dahlias
dahls95012283da__hls
dahs88231813da__h_s
dancers103413093dancers
dances95120653danc_es
darshan1167063darshan
darshans1286543darshans
dashes106124983da_shes
dashis104414393da_shis
data56026653dat__a_
database1143533database
daters74827373dat_ers
dates65639153dat__es
datival1135583datival
datives11310073datives
datos65222783dat__os
dattos74311903dat_tos
datums936353dat_ums
datura738033datura_
deaths105914443deat_h_s
detaches1439653detaches
ditas65923673dit__as
ditch115015093ditch__
ditched143711903ditched
ditcher134012003ditcher
ditchers143610363ditchers
douches134315233douches
drachmas1644863drachmas
drachms1534253drachms
dunches133312583dunches
dutch114713823dutch__
dutchman1643013dutchman
etches114217763_etches
facias113415803fa_cias
fascias1258413fascias
fatwas1249053fat_was
fetches153413893fetches
fitches153516193fitches
gauchos1345903gauchos
gotcha1234633gotcha_
hahas117118443ha__has
halachas16317893halachas
hatch135719593hatch__
hatched163414463hatched
hatchel153510753hatchel
hatchels16368673hatchels
hatcher153314723hatcher
hatchers163113173hatchers
hatchet153317563hatchet
hatchets163310383hatchets
hatchway2243293hatchway
hatchways2342663hatchways
hitches153616273hitches
hotches153814363hotches
hutches153613523hutches
itches114916213_itches
kashas133311903ka_shas
katas95922093kat__as
katchinas1843923katchinas
katcinas1434513katcinas
ketches164012193ketches
klatches17157143klatches
kwachas1943063kwachas
laches116528353la_ches
laichs115110893laich_s
larches124416453larches
latch104620463latch__
latched133914073latched
latchet123117913latchet
latchets133410013latchets
lathes95127503lat_hes
lathis95516173lat_his
laths86022403lat_h_s
latinas74416463latinas
latrias71913213latrias
letches124015483letches
litchis1238373litchis
maches134827233ma_ches
machos135217493ma_chos
machs125722563ma_ch_s
malthas1237913malthas
manches143818623manches
marches143921173marches
match125621103match__
matched153513963matched
matcher143214283matcher
matchers153012433matchers
matchup1643513matchup
matchups1743073matchups
maths105624023mat_h_s
matsahs1236563matsahs
matzahs2134483matzahs
matzas1749703mat_zas
mochas13310663_mochas
mutches143314283mutches
naches114622413na_ches
nachos115014183na_chos
natch105018223natch__
nautches1336083nautches
notches123513653notches
oaths86117313oat_h_s
pacas96029403pa_c_as
pacha126518063pa_cha_
pakehas1635313pakehas
panchax2134983panchax
panochas1545653panochas
parches143720003parches
paschal14157243paschal
paschals1566473paschals
pashas115117063pa_shas
patacas11311003patacas
patch125221223patch__
patched153514623patched
patcher143515143patcher
patchers153413303patchers
patchy16509573patch_y
pathos115516693pat_hos
paths105521383pat_h_s
patinas96318523patinas
pitches143617753pitches
rachis114017653ra_chis
ranches123620113ranches
ranchos123911393ranchos
ratch104221363ratch__
ratchet124218333ratchet
ratchets133110263ratchets
retches123318513retches
rotches123515703rotches
sataras7315063sataras
satchel123310303satchel
satchels13328163satchels
sauchs115112233sauch_s
slatches131511533slatches
snatches131410713snatches
swatches16169963swatches
taches114224173ta_ches
tachs105820933ta_ch_s
thatches1637513thatches
vetches153411263vetches
watch135617063watch__
watchcase1942773watchcase
watched163012823watched
watcher153113403watcher
watchers163511793watchers
watchman1844623watchman
wauchts15285283wauchts
witches152715793witches
yachts1437023ya_chts

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.390458182.1
2DLD Change Limit1340272136.90619407.3
3Display Results2132130.0762802.6
 (SQL Overall)1786912137.37224239.1
 
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.