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

159 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
gotcha123463(None) 
gotchas1334611gotchas
botch126717452botch_
botchy16537822botchy
concha134213282concha
datcha1266562datcha
goth86825082got_h_
goths96513002got_hs
hotch136214732hotch_
mocha1249922mo_cha
notch105613322notch_
rotch105815932rotch_
rotche114311982rotche
aitch105216163aitch_
batch124620103batch_
bitch125017763bitch_
bitchy16479203bitchy
blotch13197143blotch_
blotchy17293973blotchy
boccia12338793boccia
boche124216953bo_che
bota66236503bot__a
botched153611903botched
botcher143613223botcher
botches143716023botches
both96533433bot_h_
bothy136713963bot_hy
butch125416543butch_
cancha134411613cancha
catch125120373catch_
catchy16559583catchy
coach125919453coach_
coca88030643co_c_a
cocoa98517883co_coa
conch124620073conch_
conchae143911643conchae
conchal144211583conchal
conchas144013313conchas
concho134414263concho
conchs134714903conchs
conchy163710223conchy
cooch124916833cooch_
cotta75818573cot_ta
couch125320113couch_
crotch133410083crotch_
cutch125116193cutch_
dacha114812573_dacha
datchas1347423datchas
ditch115015093ditch_
doth86225713dot_h_
douche124613223douche
dutch114713823dutch_
etch95419143_etch_
fetch134913473fetch_
fitch134816873fitch_
fitchy17437623fitchy
gauche1238553gauche
gaucho1256223gaucho
geisha1035203geisha
geta56627443get__a
glitch12286353glitch_
glitchy16283083glitchy
gnocchi1541923gnocchi
goa47343803go___a
goanna736653goanna
gonia64117533go_nia
gosh86123423go_sh_
got49870443got___
gothic1237793gothic
gotten73410113gotten
gouache1335033gouache
grouch12318473grouch_
grouchy16294243grouchy
grutch12285563grutch_
gulch113810603gulch_
gutta64613383gut_ta
gyttja1741573gyttja
hatch135719593hatch_
hitch134515473hitch_
honcho14389383honcho
hooch135813703hooch_
hootch14386413hootch_
hotched163610923hotched
hotches153814363hotches
hutch135414093hutch_
iota45127833iot__a
itch95619173_itch_
itchy13449013_itchy
jota116423623jot__a
ketch144912023ketch_
kwacha1832983kwacha
latch104620463latch_
letch105215803letch_
litchi1137893litchi
loach105116363loach_
loca65527683lo_c_a
loch95527133lo_ch_
lochan1139093lo_chan
lochia1158313lo_chia
lochs106715513lo_chs
lota47233503lot__a
lotah85315853lotah_
lotahs9479873lotahs
loth76132133lot_h_
louche115212663louche
match125621103match_
mochas13310663mo_chas
mooch125313613mooch_
moth96731333mot_h_
moths106021553mot_hs
mothy136214553mot_hy
mouch124715803mouch_
mutch125016173mutch_
natch105018223natch_
nota46830773not__a
notched134210303notched
notcher123610933notcher
notches123513653notches
nucha10229793_nucha
oca56731733_o_c_a
orca65522773_orc_a
ouch95724633_ouch_
pacha126518063_pacha
patch125221223patch_
patchy16509573patchy
pitch125018413pitch_
pitchy16479673pitchy
poach124917863poach_
poachy16388963poachy
poisha1135723poisha
poncho133310123poncho
pooch124815303pooch_
porch125918623porch_
potiche1438043potiche
pouch124617083pouch_
pouchy16538663pouchy
quotha18365113quot_ha
ratch104221363ratch_
retch104818303retch_
roach105717003roach_
rota45834343rot__a
rotches123515703rotches
rouche114714313rouche
scotch13207523scotch_
soca66330053so_c_a
soth75932523sot_h_
soths86218633sot_hs
tetchy1436003tetchy
torch107420933torch_
torchy14549533torchy
touch106519393touch_
touche114916173touche
touchy145010503touchy
vetch134411843vetch_
vouch134611903vouch_
watch135617063watch_
witch134517563witch_
witchy17468593witchy
zoecia1735553zoecia

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.1231452772.4
2DLD Change Limit1127161595.42320784.8
3Display Results1591590.0463456.5
 (SQL Overall)1786911595.59231954.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.