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

160 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
grutched1528467(None) 
crutched16307461crutched
grutches14285851grutches
brunched16317852brunched
clutched16356032clutched
crotched16428602crotched
crunched16328162crunched
crutches15359592crutches
glunched1544262glunched
grouched15356662grouched
grutch12285562grutch__
hutched16359882_hutched
retched133814272_retched
ruched124314632_ru_ched
scutched16186892scutched
smutched16165922smutched
wretched17276532wretched
arched125717323ar__ched
batched154114243_batched
bitched153212923_bitched
blotched1635653blotched
botched153611903_botched
branched163210453branched
breached163411643breached
breeched16337383breeched
britches15278683britches
broached16309123broached
bruncher15347783bruncher
brunches153710453brunches
brushed133811213bru_shed
bruted95113263brut__ed
bunched154312413_bunched
butcher143411163_butcher
butches144315363_butches
churched1934653churched
clutches15307923clutches
couched154115793cou_ched
cranched163210413cranched
cratches153012543cratches
craunched1764023craunched
crotches153411303crotches
crotchet152711993crotchet
crouched16359153crouched
cruncher15338073cruncher
crunches153711353crunches
crushed134111973cru_shed
crutch13408243crutch__
cutches143216463_cutches
ditched143711903_ditched
douched144012113dou_ched
drenched15247913drenched
eructed10228653eru_cted
etched123613703__etched
fetched163710473_fetched
fletched17306693fletched
flitched17256293flitched
frenched17299433frenched
frothed14288783frot_hed
gauche1238563gau_che_
gaucher1337243gau_cher
girthed12266243girt_hed
glitches14296663glitches
glunches1436263glunches
glutted937243glut_ted
gouache1335043gouache_
gouaches1436203gouaches
graced105217903gr_ac_ed
graphed1498473gr_aphed
grated84523923grat__ed
grinches1436953grinches
gritted94110903grit_ted
groschen1442973groschen
grottoed10234503grottoed
grouches14328213grouches
grouted94111503grout__ed
grubbed13406433gru_bbed
grudged11317163gru_dged
grueled937133gru_eled
gruelled1034893gruelled
gruffed1544943gru_ffed
grumbled14256753grumbled
grumped13337333gru_mped
grunted9339283gru_nted
gruntled10274943gruntled
grutching16224373grutching
grutten885283grut_ten
gulches13398113g_ulches
gushed114816243g_u_shed
gutted84716363g_ut_ted
guttled9378993g_uttled
hatched163414463_hatched
haunched1744813haunched
hitched163312253_hitched
hotched163610923_hotched
hunched163710493_hunched
hutches153613523_hutches
itched123812023__itched
kvetched2142783kvetched
latched133914073_latched
launched1475403launched
letched133912053_letched
lunched133911823_lunched
lurched13358033_lurched
matched153513963_matched
mouched153612593mou_ched
mouthed133811043mout_hed
mulched15307763_mulched
munched153411073_munched
mutches143314283_mutches
nautches1336083nautches
notched134210303_notched
ouched124316933_ou_ched
outchid1338723_outchid
patched153514623_patched
paunched1645523paunched
pitched153512923_pitched
pouched153612773pou_ched
preached163412063preached
punched153512173_punched
ranched133113603_ranched
ratches123620463_ratches
ratchet124218333_ratchet
reached134619083_reached
retches123318513_retches
roached133211833_roached
rotche114311983_rotche_
rotches123515703_rotches
ruche104216763_ru_che_
ruches114819583_ru_ches
rucked134718763_ru_cked
rushed104419863_ru_shed
rutted74518403_rut_ted
scotched16187933scotched
scratched1735393scratched
scrunched1744033scrunched
scutcher15176963scutcher
scutches15168883scutches
sketched1835393sketched
smutches15177273smutches
snatched14157633snatched
snitched14166863snitched
southed114313993sout_hed
stitched14148203stitched
stretched1546213stretched
switched17157133switched
tetched133010773_tetched
thatched1735433thatched
touched134914963tou_ched
trenched14289853trenched
trothed114010973trot_hed
truced95312053tru_c_ed
trucked143910813tru_cked
twitched17155033twitched
vouched163910563vou_ched
watched163012823_watched
witched163012193_witched
wrathed14298523wrat_hed
wrenched17748133wrenched
wretches16257283wretches
writhed14389623writ_hed

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.453394461.4
2DLD Change Limit1461621607.43619656.0
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.95222471.2
 
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.