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

193 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
scooches1518841(None) 
cooches143515831_cooches
scooched16206681scooched
scootches1635001scootches
scorches15189141scorches
scotches15179471scotches
scrooches1645701scrooches
smooches15217261smooches
brooches15288192brooches
cloches144113712_cloches
coaches144018692_coaches
conches144019812_conches
couches144020472_couches
hooches153812522_hooches
mooches143714452_mooches
pooches143214162_pooches
sconces113811452sconc_es
scooch13228122scooch__
scootched1763962scootched
scorched16187192scorched
scorcher15196782scorcher
scorchers16145512scorchers
scotched16187932scotched
scrooched1763842scrooched
scrootches1743322scrootches
sculches15176272sculches
scutches15168882scutches
slouches13208072slouches
smooched16185982smooched
smoocher15205502smoocher
smoochers16184832smoochers
smooshes13206862smooshes
smoothes13218542smoothes
soothes103917112s_oothes
soroches1338802soroches
swooshes14185122swooshes
avouches1634823avouches
bescorches1942743bescorches
blotches1537433blotches
boches134618523__boches
botches143716023_botches
brioches15227253brioches
broaches153211623broaches
caches137926913_c_aches
caroches15710693caroches
catches144320773_catches
cinches144215773_cinches
cliches144213743_cliches
cloche134312373_cloche_
clothes124513813_clothes
coached153313843_coached
coacher143714123_coacher
coachers154312303_coachers
cohoshes1635883_cohoshes
conchas144013313_conchas
conchies153214853_conchies
conchos144313963_conchos
conchs134714903_conch_s
cooch124916833_cooch__
cooees85621893_coo_ees
cookies133719273_cookies
coolies93824963_coolies
coombes133810663_coombes
cooties93725733_cooties
coshes115022783_c_oshes
couched154115793_couched
coucher144515853_coucher
couchers153513863_couchers
creches14313093_creches
crochet143616663_crochet
crochets15359833_crochets
crotches153411303crotches
crouches153711293crouches
culches143710743_culches
curches143512743_curches
cutches143216463_cutches
douches134315233_douches
grouches14328213grouches
hoochies1639603_hoochies
hootches1656973hootches
hotches153814363_hotches
loaches123613983_loaches
mooched153910533_mooched
moocher143610673_moocher
moochers15369123_moochers
mouches143815963_mouches
notches123513653_notches
ouches114322183__ouches
panoches1548123panoches
penoches1538933penoches
poaches144416943_poaches
pooched152810083_pooched
porches143815673_porches
pouches144116743_pouches
roaches123616213_roaches
rotches123515703_rotches
rouches124217893_rouches
scathes124515713sc_athes
scoleces1237083scoleces
scolices1238733scolices
sconce104711723sconc_e_
sconced12359173sconc_ed
sconcheon1642373sconcheon
sconcheons1742093sconcheons
scones84521303sc_o_nes
scooching1735073scooching
scooped124611743scoo_ped
scooper113812033scoo_per
scoopers124210193scoopers
scoops105414363scoo__ps
scootch1434463scootch__
scooted103612283scoo_ted
scooter93312873scoo_ter
scooters103511033scooters
scoots85315943scoo__ts
scopes104719593sc_o_pes
scorch13198093scorch__
scores84725923sc_o_res
scotch13207523scotch__
scotties1039753scotties
scourges1136533scourges
scouses93313243sc_ouses
scouther1356943scouther
scouthers1445993scouthers
scouths12527893scouth_s
scratches1647323scratches
screeches1695643screeches
scrooch1444953scrooch__
scrooges1137163scrooges
scrootched1842333scrootched
scrouges1136683scrouges
scrunches1635403scrunches
scultches1664293scultches
scutched16186893scutched
scutcher15176963scutcher
scutchers16175643scutchers
scythes15356523sc_ythes
searches132112903searches
seiches12513813s_eiches
seviches1635803seviches
sketches1746823sketches
skoshes14246253s_koshes
slatches131511523slatches
sloshes103811803s_loshes
slouched14206743slouched
sloucher13206813sloucher
slouchers14185623slouchers
smirches1535993smirches
smooch13266803smooch__
smoochy17223863smooch_y
smooshed14185993smooshed
smoothed14236473smoothed
smoothen13204963smoothen
smoothens14194253smoothens
smoother13196673smoother
smoothers14206043smoothers
smoothest14215773smoothest
smoothies1456133smoothies
smooths12216323smooth_s
smutches15177273smutches
snatches131410713snatches
snitches13148983snitches
snoozes16289783snoo_zes
snoozles17335563snoozles
socles8418453s__ocles
soothe94214853s_oothe_
soothed113712743s_oothed
soother104215043s_oother
soothers113913433s_oothers
soothest113312243s_oothest
sooths95715593s_ooth_s
soroche1237183soroche_
speeches1537413speeches
sploshes1336133sploshes
splotches1643913splotches
spoonies101911753spoonies
squooshes2142543squooshes
stanches132312793stanches
starches131912913starches
stenches132110293stenches
stitches131410593stitches
stooges83611483stoo_ges
stoolies8311083stoolies
strophes13310603strophes
swatches16169963swatches
switches16159133switches
swooshed15174273swooshed
torches123715433_torches
touches125118343_touches
troches123715343_troches
vouches153914113_vouches
whooshes1734423whooshes
wooshes13169883_wooshes

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621936.97020970.2
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.52923733.7
 
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.