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

231 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
grouches1432821(None) 
crouches153711291crouches
grouched15356661grouched
rouches124217891_rouches
avouches1634822avouches
barouches1644972barouches
broaches153211622broaches
brooches15288192brooches
couches144020472_couches
crotches153411302crotches
crouched16359142crouched
douches134315232_douches
gouaches1436192g_ouaches
grinches1436942grinches
groschen1442972groschen
grouch12318472grouch__
grouchier1543842grouchier
grouchiest1644122grouchiest
grouchy16294242grouch_y
groupies1137522groupies
grouses84616542grou_ses
grutches14285852grutches
mouches143815962_mouches
ouches114322182__ouches
pouches144116742_pouches
roaches123616212_roaches
rotches123515702_rotches
rouche114714312_rouche_
ruches114819582_r_uches
slouches13208072slouches
touches125118342_touches
troches123715342tro_ches
vouches153914112_vouches
arches114822043ar__ches
arouses74921293arou_ses
avouched1743583avouched
avoucher1653853avoucher
avouchers1743083avouchers
barouche1544173barouche_
blotches1537433blotches
boches134618523_bo_ches
borsches1536003borsches
botches143716023_botches
bouchee143313543_bouchee
bouchees15339533_bouchees
boucles113113003_boucles
braches144621223br_aches
branches153613803branches
breaches153714123breaches
breeches15258673breeches
brioches15227253brioches
britches15278683britches
broached16309123broached
broacher15329263broacher
broachers16328153broachers
broche133612103bro_che_
bronchos15206173bronchos
bronchus15204743bronchus
brunches153710453brunches
brushes124014663br_ushes
capouches1843633capouches
capuches1735513capuches
caroaches1637793caroaches
caroches15710693caro_ches
cartouches17112953cartouches
choushes1637623choushes
cloches144113713clo_ches
coaches144018693_coaches
conches144019813_conches
cooches143515833_cooches
couched154115793_couched
coucher144515853_coucher
couchers153513863_couchers
cranches153114543cranches
cratches153012543cratches
craunches1655723craunches
creches14313093cr_eches
crochet143616663cro_chet
crochets15359833cro_chets
crocuses1239023crocuses
crotched16428593crotched
crotchet152711993crotchet
crotchets16396303crotchets
crouch133910203crouch__
croupes114613103crou_pes
croutes94815653crou_tes
cruces105117543cr_uc_es
crunches153711353crunches
crushes124215133cr_ushes
crutches15359593crutches
debouches17124103debouches
douche124613223_douche_
douched144012113_douched
drenches14309803drenches
droughts13245733droughts
drouths11436483drouth_s
farouche1643053farouche_
frenches163311633frenches
frounces1336183frounces
ganaches1437413ganaches
gauche1238553g_auche_
gaucher1337233g_aucher
gauchest1436293g_auchest
gauchos1345903g_auchos
ghoulies1235393ghoulies
glitches14296653glitches
glunches1436263glunches
gotchas1334613g_otchas
gouache1335033g_ouache_
gouges86318693g_ou_ges
gourdes9109383g_ourdes
graces94523493gr_ac_es
grocer94212143gro_c_er
grocers103511253gro_cers
grooves11368803gro_oves
gropes95220403gro__pes
grosses84517683gro_sses
grottoes9276753grottoes
grouchily1842843grouchily
grouchiness1742763grouchiness
grouching1644943grouching
grounded1136573grounded
grounder1047613grounder
grounders1156783grounders
grounds9228313grou_nds
grouped11419193grou_ped
grouper104210093grou_per
groupers11358643groupers
groupie1045783groupie_
groups94210513grou__ps
grouse74315023grou_se_
groused94712833grou_sed
grouser84513693grou_ser
grousers93810733grousers
grouted94111503grou_ted
grouter84412523grou_ter
grouters95910083grouters
groutier9297173groutier
groutiest10147763groutiest
grouts75015613grou__ts
groves104318103gro__ves
growths1494423growth_s
groynes1137823gro_ynes
grudges10349423gr_udges
grues65721963gr_u__es
grumes94415553gr_u_mes
grunges93310403gr_unges
grutched15284673grutched
gulches13398103g_ulches
gushes104719033g__ushes
hooches153812523_hooches
hootches1656973hootches
hotches153814363_hotches
loaches123613983_loaches
louche115212663_louche_
mooches143714453_mooches
mouched153612593_mouched
muches134718993__muches
notches123513653_notches
oraches124216473or_aches
ouched124316933__ouched
ouphes113614633__ouphes
penuches1536943penuches
poaches144416943_poaches
pooches143214163_pooches
porches143815673_porches
pouched153612773_pouched
preaches153214893preaches
procures1239213procures
produces1347903produc_es
ranches123620113_ranches
ratches123620463_ratches
raunches1368053_raunches
reaches123423203_reaches
retches123318513_retches
retouches1445903retouches
riches115022083_r_iches
roached133211833_roached
rochet115423003_ro_chet
rochets124213473_ro_chets
roscoes9310923_roscoes
rotche114311983_rotche_
roubles93413513_roubles
roues56039353_rou__es
rouges76022383_rou_ges
roughed124210943_roughed
roughen11338833_roughen
roughens12286893_roughens
rougher113511033_rougher
roughers12329183_roughers
roughest1238773_roughest
roughies1298323_roughies
roughs105416213_rough_s
rouses65436283_rou_ses
routes66129313_rou_tes
rouths95416823_routh_s
ruche104216763_r_uche_
ruched124314633_r_uched
rushes94724363_r_ushes
scooches15188413scooches
scorches15189143scorches
scotches15179473scotches
scrooches1645703scrooches
slouched14206743slouched
sloucher13206813sloucher
slouchers14185623slouchers
smooches15217263smooches
soroches1338803soroches
torches123715433_torches
touche114916173_touche_
touched134914963_touched
toucher124814353_toucher
touchers133611213_touchers
tranches132915513tranches
trauchles1445493trauchles
trenches133512603trenches
troche113112513tro_che_
trochee122613883tro_chee
trochees132510183tro_chees
troubles1057203troubles
troughs11698683trough_s
trounces1037063trounces
troupes94112853trou_pes
truces84916333tr_uc_es
vouched163910563_vouched
vouchee153411263_vouchee
vouchees16337483_vouchees
voucher154110263_voucher
vouchers16418623_vouchers
wrenches163210233wrenches
wretches16257283wretches

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.1561145455.1
2DLD Change Limit1461622317.11020557.2
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.35924282.0
 
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.