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

176 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
soroches133880(None) 
soroche1237181soroche_
borsches1536002borsches
brooches15288192brooches
caroches15710692caroches
cooches143515832co_oches
hooches153812522ho_oches
mooches143714452mo_oches
oraches124216472_oraches
pooches143214162po_oches
porches143815672por_ches
scooches15188412scooches
scorches15189152scor_ches
scrooches1645702scrooches
smooches15217262smooches
soothes103917112so_othes
soroses73117492soro_ses
strophes13310602strophes
torches123715442tor_ches
troches123715342_troches
arches114822043_ar_ches
aurochs1245983auroch_s
aurochses1444143aurochses
barouches1644973barouches
birches143412323bir_ches
bobeches1744483bobeches
boches134618523__boches
boraces113716853borac_es
borschts1542853borschts
botches143716023bo_tches
braches144621223_braches
brioches15227253brioches
broaches153211623broaches
broche133612103_broche_
caroaches1637793caroaches
caroche1469243caroche_
carroches1665893carroches
cloches144113713_cloches
coaches144018693co_aches
cohoshes1635883cohoshes
conches144019813co_nches
coracles121811163coracles
corniches1666673corniches
corodies11313693corodies
couches144020473co_uches
creches14313093_creches
crochet143616663_crochet
crochets15359833_crochets
crotches153411303crotches
crouches153711293crouches
curches143512743cur_ches
douches134315233do_uches
earaches13411313earaches
enriches1337263enriches
forces114422133for_c_es
goloshes1236263goloshes
gouaches1436203gouaches
grouches14328213grouches
hoochies1639603ho_ochies
hootches1656973hootches
hotches153814363ho_tches
kirsches1743843kirsches
larches124416453lar_ches
loaches123613983lo_aches
lurches123311663lur_ches
marches143921173mar_ches
merches144013763mer_ches
molochs1435223moloch_s
monocles12310673monocles
mooched153910533mo_oched
moocher143610673mo_ocher
moochers15369123mo_ochers
moroccos1443813moroccos
mouches143815963mo_uches
notches123513653no_tches
orache114013593_orache_
oracles93212423_oracles
orchis11710773_or_chis
oroides8311973_oroides
ostriches1446633ostriches
ouches114322183_o_uches
panoches1548123panoches
parches143720003par_ches
penoches1538933penoches
perches143717953per_ches
poaches144416943po_aches
pooched152810083po_oched
potiches1539203potiches
pouches144116743po_uches
riches115022083__riches
roaches123616213ro_aches
rochet115423003__rochet
rochets124213473__rochets
rotches123515703ro_tches
rouches124217893ro_uches
ruches114819583__ruches
sarodes84216143saro_des
saroses73619333saro_ses
scooched16206683scooched
scootches1635003scootches
scorched16187203scor_ched
scorcher15196793scor_cher
scorchers16145513scor_chers
scotches15179473scotches
scratches1647323scratches
screeches1695653screeches
scrooched1763843scrooched
scrooges1137163scrooges
scrootches1743323scrootches
scrouges1136683scrouges
scrunches1635403scrunches
sculches15176273sculches
scutches15168883scutches
searches132112903searches
seiches12513813s_eiches
seviches1635803seviches
siroccos1242803siroccos
sketches1746823sketches
skoshes14246253s_koshes
slatches131511533slatches
sloshes103811803s_loshes
slouches13208073slouches
smirches1535993smirches
smooched16185983smooched
smoocher15205503smoocher
smoochers16184833smoochers
smooshes13206863smooshes
smoothes13218543smoothes
smutches15177273smutches
snatches131410713snatches
snitches13148983snitches
socles8418453s__ocles
sodomies11128553sodomies
solaces93116133solac_es
soothe94214853so_othe_
soothed113712743so_othed
soother104215043so_other
soothers113913433so_others
soothest113312243so_othest
sooths95715593so_oth_s
sorbates10311103sorbates
sorboses1038523sorboses
sordines92414073sordines
sores55454283sor___es
sorghos11327603sor_ghos
sorites73825243sor_ites
sororates9410473sororates
sorosis72611973soro_sis
sorosises947303sorosises
sorties74126403sor_ties
sources9312173sourc_es
soutaches1446443soutaches
speeches1537413speeches
sploshes1336133sploshes
splotches1643913splotches
sprocket1646773sprocket
sprockets1743253sprockets
spruces113810503spruc_es
stanches132312793stanches
starches131912913starches
stenches132110293stenches
stitches131410593stitches
stretches1438293stretches
strobes93813263stro_bes
strokes114316323stro_kes
strophe1239143strophe_
swatches16169963swatches
switches16159133switches
swooshes14185123swooshes
torched133511363tor_ched
touches125118343to_uches
troche113112513_troche_
trochee122613883_trochee
trochees132510183_trochees
vouches153914113vo_uches
wooshes13169883wo_oshes

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.406440125.6
2DLD Change Limit1461621766.78021557.8
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.26624592.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.