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

138 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
drouthy1439517(None) 
drouth104410101drouth_
drouths11436481drouths
brothy14519622bro_thy
doughy14499842d_oughy
drought12258872drought
droughty16304472droughty
frothy15578372fro_thy
grouchy16294242grouchy
grouty104710982grout_y
growthy1773282growthy
mouthy14409062_mouthy
roughy137010852_roughy
routh86423072_routh_
rouths95416822_rouths
trouty95211792trout_y
adroitly1243363adroitly
agouty10366913agout_y
bothy136713963_bo_thy
breathy15328033breathy
broth106521093bro_th_
broths115013923bro_ths
brought13308683brought
brushy14468263br_ushy
couth106122483_couth_
couths115715393_couths
crouch133910203crouch_
croupy13458733crou_py
croute84617273crout_e
croutes94815643croutes
crouton947133crouton
deathy134210233d_eathy
deputy12426713deput_y
devoutly1542663devoutly
doeth9411983d_oeth_
dorty96220813d_ort_y
doth86225713d_o_th_
dotty94516103d_o_tty
doty86128223d_o_t_y
doubly12328963d_oubly
douche124613223d_ouche
dough105217383d_ough_
doughs115912933d_oughs
dought114915513d_ought
doughty15436023d_oughty
dourly103210433d_ourly
drafty13638933draft_y
draught12266963draught
draughty16233523draughty
drifty13418223drift_y
droit65127123droit__
droits74314313droit_s
drolly105411673dro_lly
drooly104911073dro_oly
droopy12458243dro_opy
dropsy12497473dro_psy
dropt86924433dropt__
droshky1841973droshky
drosky14486163dro_sky
drossy10528473dro_ssy
droughts13245733droughts
drouk1039433drou__k
drouked1335543drouked
drouks1137123drou_ks
drouthier1343033drouthier
drowsy13487903dro_wsy
druggy12344743dr_uggy
drumly1235703dr_umly
duchy144310873d__uchy
duty85321453d__ut_y
frosty124710633frost_y
froth115919283fro_th_
froths125411443fro_ths
frouzy21395283frou_zy
gouty95217363_gout_y
grotty10389833gro_tty
grouch12318473grouch_
grout65330423grout__
grouted94111503grouted
grouter84412523grouter
grouts75015613grout_s
growth1377383growth_
growths1494423growths
mothy136214553_mo_thy
mouth105420293_mouth_
mouths115214533_mouths
outby10411533__outby
pouchy16538663_pouchy
pouty107018813_pout_y
proudly1336323proudly
rooty86423023_root_y
rouche114714313_rouche
rough97819433_rough_
roughly14507293_roughly
roughs105416213_roughs
roupy106112713_rou_py
rout46153283_rout__
route55132073_rout_e
routed75624333_routed
router65025843_router
routes66129313_routes
routs57133413_rout_s
rowth115713233_rowth_
rowths12458173_rowths
rushy115414813_r_ushy
ruth76825993_r_uth_
ruths85714643_r_uths
rutty85617803_r_utty
scouth115011153scouth_
scouths12527893scouths
slouchy15454843slouchy
sloughy14535803sloughy
smoothy15205073smoothy
snouty9419953snout_y
south85223573_south_
souths95216603_souths
stoutly1035833stoutly
toothy12529693_toothy
touchy145010503_touchy
toughy135911073_toughy
trophy1438283tro_phy
troth85622203tro_th_
troths95414153tro_ths
trough108512023trough_
troughs11698673troughs
trout57332573trout__
trouts66116623trout_s
trowth1277883trowth_
trowths1365023trowths
truth85214153tr_uth_
truths9449503tr_uths
worthy15598803_worthy
wrathy15377853wr_athy
wreathy16326063wreathy
wroth116815883wro_th_
wrought14276923wrought
youth115315043_youth_
youths124510043_youths

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271387.03319056.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.23524698.1
 
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.