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 “botches” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
botches14371602(None) 
batches144019611batches
bitches144117061bitches
blotches1537431blotches
boches134618521bo_ches
botched153611901botched
botcher143613221botcher
botchers153511541botchers
butches144315361butches
hotches153814361hotches
notches123513651notches
rotches123515701rotches
aitches123014362aitches
baches135426942b_aches
batched154114242batched
batcher144414852batcher
batchers153613272batchers
bathes116524832bat_hes
beaches144120652beaches
beeches143413882beeches
belches143514342belches
benches143918602benches
birches143412322birches
bitched153212922bitched
bitchen14349732bitchen
blotched1635652blotched
bobeches1744482bobeches
bocces123912022bo_cces
boccies133311512boccies
boche124216952bo_che_
borsches1536002borsches
boshes114721882bo_shes
botch126717452botch__
botchery18366762botchery
botchier15287142botchier
botchiest1636152botchiest
botchy16537822botch_y
bother115218062bot_her
bothers124317752bot_hers
bothies12414782bothies
bottles94216272bottles
bouchee143313542bouchee
bouchees15339532bouchees
boucles113113002boucles
braches144621222braches
britches15278682britches
broaches153211622broaches
brooches15288192brooches
bunches144116032bunches
butcher143411162butcher
butchers153710182butchers
catches144320772catches
coaches144018692coaches
conches144019812conches
cooches143515832cooches
couches144020472couches
crotches153411302crotches
cutches143216462cutches
ditches133215712ditches
douches134315232douches
etches114217762_etches
fetches153413892fetches
fitches153516192fitches
gotchas1334612gotchas
hatches153420272hatches
hitches153616272hitches
hooches153812522hooches
hootches1656972hootches
hotched163610922hotched
hutches153613522hutches
itches114916212_itches
ketches164012192ketches
latches123320132latches
letches124015482letches
loaches123613982loaches
matches143219782matches
mooches143714452mooches
mouches143815962mouches
mutches143314282mutches
notched134210302notched
notcher123610932notcher
notchers13279422notchers
ouches114322182_ouches
patches143320382patches
pitches143617752pitches
poaches144416942poaches
pooches143214162pooches
porches143815672porches
potiches1539202potiches
pouches144116742pouches
ratches123620462ratches
retches123318512retches
roaches123616212roaches
rotche114311982rotche_
rouches124217892rouches
scotches15179472scotches
torches123715442torches
touches125118342touches
vetches153411262vetches
vouches153914112vouches
watches153017372watches
witches152715792witches

Search took 4 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 Filter1786911076710.356501941.0
2DLD Change Limit1076711023.41031575.1
3Display Results1021020.0303400.0
 (SQL Overall)1786911023.79647073.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.