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

280 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
blotches153743(None) 
blotched1635651blotched
botches143716021b_otches
batches144019612b_atches
bitches144117062b_itches
blanches153311602blanches
bleaches153410672bleaches
blenches153310762blenches
blotch13197142blotch__
blotchier1643212blotchier
blotchiest1743522blotchiest
blotchy17293972blotch_y
boches134618522b_o_ches
botched153611902b_otched
botcher143613222b_otcher
botchers153511542b_otchers
britches15278682britches
broaches153211622broaches
brooches15288192brooches
butches144315362b_utches
cloches144113712clo_ches
clothes124513812clot_hes
clutches15307922clutches
crotches153411302crotches
fletches16308852fletches
flitches16388462flitches
glitches14296652glitches
hootches1656972hootches
hotches153814362_hotches
klatches17157132klatches
latches123320122_latches
letches124015482_letches
loaches123613982_loaches
notches123513652_notches
rotches123515702_rotches
scotches15179472scotches
slatches131511522slatches
slouches13208072slouches
splotches1643912splotches
abbotcies1542623abbotcies
aitches123014363_aitches
avouches1634823avouches
babiches1735253babiches
baches135426943b__aches
barouches1644973barouches
batched154114243b_atched
batcher144414853b_atcher
batchers153613273b_atchers
bathes116524833b_at_hes
beaches144120653b_eaches
beclothes1645013beclot_hes
beeches143413883b_eeches
belches143514343b_elches
benches143918603b_enches
bewitches1943823bewitches
biotechs15123853biotech_s
biotites10310083biotites
biotopes1246963biotopes
biotypes1544683biotypes
birches143412323b_irches
bitched153212923b_itched
bitchen14349733b_itchen
blanched16308603blanched
blancher15338633blancher
blanchers16307433blanchers
blather125314203blat_her
blathers134713793blat_hers
bleached16378563bleached
bleacher15358883bleacher
bleachers16297923bleachers
blenched16358053blenched
blencher15308393blencher
blenchers16356723blenchers
blether12459913blet_her
blethers13429613blet_hers
blites84721213blit__es
blithe115810863blit_he_
blither124812173blit_her
blithers134711233blit_hers
blithest1338083blit_hest
blitzes18408703blit_zes
blocked16449983blo_cked
blocker15419923blo_cker
blockers16398793blo_ckers
blocks144513943blo_c_ks
blocs95219653blo_c__s
blokes123813883blo__kes
blondes104213163blo_ndes
bloodies11310163bloodies
blotchily1942683blotchily
blotching1734963blotching
blotless10347153blotless
blots75626173blot___s
blotted103911833blot_ted
blotter94612853blot_ter
blotters104110983blotters
blottier10336413blottier
blottiest11286833blottiest
blouses94014463blo_uses
blowtorches2151023blowtorches
blowtubes1641703blowtubes
blucher143310223bl_ucher
bluchers15359033bl_uchers
blushes124314823bl_ushes
bobeches1744483bobeches
bocces123912023b_o_cces
boccies133311513b_occies
boche124216953b_o_che_
bootees94114473boot_ees
booths115313793boot_h_s
booties94124613boot_ies
borsches1536003borsches
boshes114721883b_o_shes
botch126717453b_otch__
botchery18366763b_otchery
botchier15287143b_otchier
botchiest1636153b_otchiest
botchy16537823b_otch_y
bother115218063b_ot_her
bothers124317753b_ot_hers
bothies12414783b_othies
bottles94216273b_ottles
bouchee143313543b_ouchee
bouchees15339533b_ouchees
boucles113113003b_oucles
braches144621223b_raches
branches153613803branches
breaches153714123breaches
breeches15258673breeches
brioches15227253brioches
broached16309123broached
broacher15329263broacher
broachers16328153broachers
broche133612103bro_che_
bronchos15206173bronchos
bronchus15204743bronchus
brothel12318193brot_hel
brothels13277073brot_hels
brother123311333brot_her
brothers133410833brot_hers
broths115013923brot_h_s
brunches153710453brunches
bunches144116033b_unches
butcher143411163b_utcher
butchers153710183b_utchers
bycatches2142683bycatches
catches144320773_catches
clenches152910953clenches
cliches144213743cl_iches
clinches153910363clinches
cloche134312373clo_che_
clothe114712993clot_he_
clothed134010283clot_hed
cloths115512483clot_h_s
clotures10299023clotures
clutched16356033clutched
coaches144018693_coaches
conches144019813_conches
cooches143515833_cooches
couches144020473_couches
cratches153012543cratches
crotched16428593crotched
crotchet152711993crotchet
crotchets16396303crotchets
crouches153711293crouches
crutches15359593crutches
cultches15316533cultches
cutches143216463_cutches
ditches133215713_ditches
douches134315233_douches
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fleches153411443fl_eches
fleeches16287083fleeches
flenches163410533flenches
fletched17306693fletched
fletcher16306663fletcher
fletchers17335533fletchers
flinches16358953flinches
flitched17256293flitched
flotages1237163flotages
flysches1933123flysches
glunches1436263glunches
gotchas1334613_gotchas
grouches14328213grouches
grutches14285853grutches
hatches153420273_hatches
hitches153616273_hitches
hooches153812523_hooches
hotched163610923_hotched
hutches153613523_hutches
itches114916213__itches
ketches164012193_ketches
klatsches1842223klatsches
kvetches2053583kvetches
laches116528343_l_aches
larches124416443_larches
latched133914063_latched
latchet123117903_latchet
latchets133410013_latchets
lathes95127493_lat_hes
leaches123319343_leaches
leches115421313_l_eches
leeches123911933_leeches
letched133912053_letched
lethes94818083_let_hes
liches114724293_l_iches
litchis1238373_litchis
loathes103513243_loathes
lochs106715513_lo_ch_s
locoes85516583_lo_coes
lotahs9479873_lotah_s
lotoses73713643_lotoses
lottes65322753_lot_tes
lotuses74011253_lotuses
louche115212663_louche_
lunches124115443_lunches
lurches123311663_lurches
lyches144213613_l_yches
lynches15378873_lynches
matches143219783_matches
mooches143714453_mooches
mouches143815963_mouches
mutches143314283_mutches
nautches1336083nautches
notched134210303_notched
notcher123610933_notcher
notchers13279423_notchers
ouches114322183__ouches
patches143320383_patches
pitches143617753_pitches
planches153111863planches
pleaches153210433pleaches
plenches153110623plenches
plotties103111413plotties
plotzes18317703plot_zes
poaches144416943_poaches
pooches143214163_pooches
porches143815673_porches
potiches1539203_potiches
pouches144116743_pouches
quitches2236193quitches
ratches123620463_ratches
retches123318513_retches
roaches123616213_roaches
rotche114311983_rotche_
rouches124217893_rouches
scooches15188413scooches
scootches1635003scootches
scorches15189143scorches
scotched16187933scotched
scutches15168883scutches
sketches1746823sketches
sloshes103811803slo_shes
sloths94911893slot_h_s
slouched14206743slouched
sloucher13206813sloucher
slouchers14185623slouchers
smooches15217263smooches
smutches15177273smutches
snatches131410713snatches
snitches13148983snitches
soothes103917113soot_hes
splotched1742823splotched
stitches131410593stitches
swatches16169963swatches
switches16159133switches
thatches1637513thatches
torches123715433_torches
touches125118343_touches
troches123715343tro_ches
twitches16156373twitches
unlatches1444293unlatches
vetches153411263_vetches
vouches153914113_vouches
watches153017373_watches
witches152715793_witches
wretches16257283wretches
zloties1639913zlot_ies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622806.29623215.1
3Display Results2802800.1102545.5
 (SQL Overall)1786912806.82926166.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.