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

125 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
grouchy1629424(None) 
grouch12318471grouch_
crouch133910202crouch_
drouthy14395172drouthy
grouched15356662grouched
grouches14328212grouches
grouchily1842842grouchily
grouty104710982grou_ty
growthy1773282growthy
pouchy16538662_pouchy
rouche114714312_rouche
roughy137010852_roughy
slouchy15454842slouchy
touchy145010502_touchy
avouch1434833avouch_
barouche1544173barouche
blotchy17293973blotchy
botchy16537823_botchy
branchy17357913branchy
broach133611113broach_
broche133612103bro_che
bronchi14176313bronchi
broncho14206463broncho
brooch13368443brooch_
brothy14519623bro_thy
brought13308683brought
brushy14468263br_ushy
conchy163710223_conchy
couch125320113_couch_
crotch133410083crotch_
crouched16359143crouched
crouches153711293crouches
croupy13458733crou_py
crunchy17324763crunchy
douche124613223_douche
doughy14499843_doughy
drought12258873drought
droughty16304473droughty
drouth104410103drouth_
drouths11436483drouths
duchy144310873__duchy
farouche1643053farouche
frothy15578373fro_thy
frouzy21395283frou_zy
gauche1238553g_auche
gaucho1256223g_aucho
glitchy16283083glitchy
gnocchi1541923gnocchi
gotcha1234633g_otcha
gouache1335033g_ouache
gouty95217363g_ou_ty
grinch1238473grinch_
grocer94212143gro_cer
grocery13336763grocery
grody103412063gro__dy
groggy1234803gro_ggy
groovy13375403gro_ovy
groschen1442973groschen
grossly1175983grossly
groszy19395703gro_szy
grotty10389833gro_tty
grouchier1543843grouchier
grouching1644943grouching
ground82310273grou_nd
grounds9228313grounds
group85413923grou__p
grouped11419193grouped
grouper104210093grouper
groupie1045783groupie
groups94210513grou_ps
grouse74315023grou_se
groused94712833groused
grouser84513693grouser
grouses84616543grouses
grout65330423grou__t
grouted94111503grouted
grouter84412523grouter
grouts75015613grou_ts
growly13499173gro_wly
growth1377383growth_
growths1494423growths
grubby14324503gr_ubby
gruffy16396013gr_uffy
grumphy18443623grumphy
grumpy14498153gr_umpy
grungy11345973gr_ungy
grutch12285563grutch_
gushy125213123g__ushy
louche115212663_louche
mouch124715803_mouch_
mouthy14409063_mouthy
ouch95724633__ouch_
poachy16388963_poachy
pouch124617083_pouch_
preachy17307313preachy
proudly1336333proudly
raunchy15284313_raunchy
reechy14367823_reechy
roach105717003_roach_
rocky144513853_ro_cky
rotch105815933_rotch_
rotche114311983_rotche
rouches124217893_rouches
rough97819433_rough_
roughly14507293_roughly
roughs105416213_roughs
roupy106112713_rou_py
routh86423073_routh_
rouths95416823_rouths
ruche104216763_r_uche
rushy115414813_r_ushy
slouch11438523slouch_
sloughy14535803sloughy
smoochy17223863smoochy
torchy14549533_torchy
touch106519393_touch_
touche114916173_touche
toughy135911073_toughy
troche113112513tro_che
trophy1438283tro_phy
trough108512023trough_
troughs11698683troughs
trouty95211793trou_ty
vouch134611903_vouch_
wrought14276923wrought

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271256.53020524.8
3Display Results1251250.0502500.0
 (SQL Overall)1786911256.97025637.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.