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

123 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
gotchas133461(None) 
gotcha1234631gotcha_
botches143716022botches
conchas144013312conchas
datchas1347422datchas
goths96513002got_h_s
hotches153814362hotches
mochas13310662mo_chas
notches123513652notches
rotches123515702rotches
aitches123014363aitches
batches144019613batches
bitches144117063bitches
blotches1537433blotches
boccias13307193boccias
boches134618523bo_ches
botas75328783bot__as
botch126717453botch__
botched153611903botched
botcher143613223botcher
botchers153511543botchers
botchy16537823botch_y
butches144315363butches
canchas143212403canchas
catches144320773catches
coaches144018693coaches
cocas95926573co_c_as
cocoas104915743co_coas
concha134213283concha_
conchae143911643conchae
conchal144211583conchal
conches144019813conches
conchos144313963conchos
conchs134714903conch_s
cooches143515833cooches
cottas84615573cot_tas
couches144020473couches
crotches153411303crotches
cutches143216463cutches
dachas124113253_dachas
datcha1266563datcha_
ditches133215713ditches
douches134315233douches
etches114217763_etches
fetches153413893fetches
fitches153516193fitches
gauchos1345903gauchos
geishas1135083geishas
getas65421483get__as
glitches14296653glitches
goannas836223goannas
goas55239943go___as
goth86825083got_h__
gothic1237793got_hic
gothics1336123gothics
gouaches1436193gouaches
grouches14328213grouches
grutches14285853grutches
gulches13398103gulches
gyttjas1841003gyttjas
hatches153420273hatches
hitches153616273hitches
honchos15369573honchos
hooches153812523hooches
hootches1656973hootches
hotch136214733hotch__
hotched163610923hotched
hutches153613523hutches
iotas54821113iot__as
itches114916213_itches
jotas125717443jot__as
ketches164012193ketches
kwachas1943063kwachas
latches123320123latches
letches124015483letches
litchis1238373litchis
loaches123613983loaches
lochan1139093lo_chan
lochans1248833lo_chans
lochs106715513lo_ch_s
lotahs9479873lotah_s
lotas55926303lot__as
matches143219783matches
mocha1249923mo_cha_
mooches143714453mooches
moths106021553mot_h_s
mouches143815963mouches
mutches143314283mutches
nachas114914193_nachas
notch105613323notch__
notched134210303notched
notcher123610933notcher
notchers13279423notchers
ocas66729633_o_c_as
orcas75918623_orc_as
orchis11710773_orchis
ouches114322183_ouches
pachas135017143_pachas
patches143320383patches
pitches143617753pitches
poaches144416943poaches
ponchos143410703ponchos
pooches143214163pooches
porches143815673porches
pothos114214693pot_hos
potiches1539203potiches
pouches144116743pouches
ratches123620463ratches
retches123318513retches
roaches123616213roaches
rotas54827723rot__as
rotch105815933rotch__
rotche114311983rotch_e
rouches124217893rouches
scotches15179473scotches
socas74026183so_c_as
soths86218633sot_h_s
torches123715433torches
touches125118343touches
vetches153411263vetches
vouches153914113vouches
watches153017373watches
witches152715793witches

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271236.50020619.5
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.95225703.5
 
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.