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

188 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
grouched1535666(None) 
crouched16359141crouched
grouches14328211grouches
avouched1743582avouched
broached16309122broached
couched154115792_couched
crotched16428592crotched
crouches153711282crouches
douched144012112_douched
groschen1442972groschen
grouch12318472grouch__
grouchier1543842grouchier
grouchy16294242grouch_y
grounded1136572grounded
grouped11419192grou_ped
groused94712832grou_sed
grouted94111502grou_ted
grutched15284672grutched
mouched153612592_mouched
ouched124316932__ouched
pouched153612772_pouched
roached133211832_roached
rouche114714312_rouche_
rouches124217892_rouches
roughed124210942_roughed
ruched124314632_r_uched
slouched14206742slouched
touched134914962_touched
vouched163910562_vouched
arched125717323ar__ched
aroused84914343arou_sed
avoucher1653853avoucher
avouches1634823avouches
barouche1544173barouche_
barouches1644973barouches
blotched1635653blotched
botched153611903_botched
bouchee143313543_bouchee
boughed143810263_boughed
branched163210453branched
breached163411643breached
breeched16337383breeched
broacher15329263broacher
broaches153211623broaches
broche133612103bro_che_
brooches15288193brooches
brunched16317853brunched
brushed133811213br_ushed
capuched1843743capuched
coached153313843_coached
coucher144515853_coucher
couches144020463_couches
coughed143310903_coughed
cranched163210413cranched
craunched1764023craunched
crochet143616663cro_chet
crocked164014433cro_cked
crotches153411293crotches
crotchet152711993crotchet
crouch133910203crouch__
crunched16328163crunched
crushed134111963cr_ushed
crutched16307463crutched
debouched18123633debouched
douche124613223_douche_
douches134315233_douches
drenched15247913drenched
drouked1335543drou_ked
eructed10228653er_ucted
farouche1643053farouche_
frenched17299433frenched
frocked17439333fro_cked
frothed14288783fro_thed
frounced1434493frounced
gauche1238553g_auche_
gaucher1337233g_aucher
glochid1445263glo_chid
glouted9429713glou_ted
glunched1544263glunched
gouache1335033g_ouache_
gouaches1436193g_ouaches
gouged96214593g_ou_ged
graced105217903gr_ac_ed
graphed1498473gr_aphed
grinches1436943grinches
groaned9259973gro_aned
grocer94212143gro_c_er
groined92710813gro_ined
grokked1233673gro_kked
groomed11379503gro_omed
grooved12347253gro_oved
groped107515053gro__ped
grossed93812253gro_ssed
grottoed10234503grottoed
grouchiest1644123grouchiest
grouchily1842843grouchily
grouching1644943grouching
ground82310273grou__nd
grounder1047603grounder
grouper104210093grou_per
groupie1045783groupie_
groupies1137523groupies
groupoid1243263groupoid
grouse74315023grou_se_
grouser84513693grou_ser
grouses84616543grou_ses
grouter84412523grou_ter
groutier9297173groutier
groved114413703gro__ved
groveled13345453groveled
growled12278163gro_wled
grubbed13406433gr_ubbed
grudged11317163gr_udged
grueled937133gr_ueled
gruffed1544943gr_uffed
grumped13337333gr_umped
grunted9339283gr_unted
grutches14285853grutches
gushed114816243g__ushed
hotched163610923_hotched
louche115212663_louche_
mooched153910533_mooched
mouches143815963_mouches
mouthed133811043_mouthed
notched134210303_notched
ouches114322183__ouches
ploughed15204303ploughed
poached154212403_poached
pooched152810083_pooched
pouches144116743_pouches
preached163412063preached
proceed12310543pro_ceed
procured1336603procured
produced1456073produc_ed
ranched133113603_ranched
reached134619083_reached
retched133814273_retched
retouched1545113retouched
roaches123616213_roaches
rochet115423003_ro_chet
rocked135022323_ro_cked
rotche114311983_rotche_
rotches123515703_rotches
rouged86717323_rou_ged
roughen11338833_roughen
rougher113511033_rougher
rounded93013503_rounded
rouped95717353_rou_ped
roused75426443_rou_sed
rousted84013323_rousted
routed75624333_rou_ted
ruche104216763_r_uche_
ruches114819583_r_uches
rucked134718763_r_ucked
rushed104419863_r_ushed
scooched16206683scooched
scorched16187193scorched
scotched16187933scotched
scrooched1763843scrooched
sloucher13206813sloucher
slouches13208073slouches
sloughed13305583sloughed
smooched16185983smooched
soughed123811623_soughed
southed114313993_southed
torched133511353_torched
touche114916173_touche_
toucher124814353_toucher
touches125118343_touches
toughed123511693_toughed
trauchled1543733trauchled
trenched14289853trenched
troche113112513tro_che_
trochee122613873tro_chee
troches123715343tro_ches
trocked144312243tro_cked
trothed114010973tro_thed
troubled1134973troubled
trounced1135033trounced
trouped103910973trou_ped
truced95312053tr_uc_ed
trucked143910813tr_ucked
untouched1544413untouched
vouchee153411263_vouchee
voucher154110263_voucher
vouches153914113_vouches
wrenched17748133wrenched
wretched17276533wretched

Search took 10 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.1731032896.0
2DLD Change Limit1461621888.87316472.7
3Display Results1881880.0632984.1
 (SQL Overall)1786911889.10919617.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.