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

106 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
druggets1131391(None) 
drugget10337611drugget_
draggers11357382draggers
dragnets10136562dragnets
drudgers11326842drudgers
drudges10308872drudge_s
drugged11367172drugge_d
druggies11126222druggies
druggiest12134972druggiest
druggist11163662druggist
druggists12112132druggists
nuggets936382_nuggets
ruggers94612312_ruggers
braggers12327903braggers
braggest1296533braggest
brunets9419553bru_nets
budgets11489863_budgets
buggers114315663_buggers
chuggers1554853chuggers
cruets85314953cru__ets
crumpets14335943crumpets
crusets93811043cru_sets
daggers103714913d_aggers
debuggers1442713debuggers
diggers104413383d_iggers
doggers104413433d_oggers
doublets11257363doublets
drabbets13294823drabbets
dragees9359483dr_agees
dragged11379553dragge_d
dragger10309163dragge_r
draggiest12126413draggiest
draggles1145963draggles
dragnet91211433dragnet_
dragonets11134503dragonets
draughts13284753draughts
dredgers11256093dredgers
dredges10379343dredge_s
dreggiest12124543dreggiest
driblets11266093driblets
drogues9398393drogue_s
droplets1136063droplets
droughts13245733droughts
drubbers13386023drubbers
drudge9317903drudge__
drudged11277613drudge_d
drudger10328323drudge_r
drudgery14273633drudgery
druggie10134073drugg_ie
druggier11134833druggier
drugging12326443drugging
druggy12344743drugg__y
drugs75214653dru_g__s
druidess1043083druidess
drumbeats1442323drumbeats
drummers13316163drummers
drunkest1334423drunkest
drupelets1242683drupelets
drupes94912653dru_pe_s
druses75517253dru_se_s
druthers1275793druthers
duets65323883d_u__ets
dugouts935043d_ugouts
dulcets1046283d_ulcets
duvets1039223d_u_vets
froglets1235263froglets
frugged13387283frugge_d
grudgers11266743grudgers
grudges10349423grudge_s
grummets13275033grummets
grungers10298503grungers
grunges93310403grunge_s
guglets9369693_guglets
gurglets10355543gurglets
hoggets12498323_hoggets
huggers124211593_huggers
loggets9378913_loggets
luggers93713483_luggers
muggees11338883_muggees
muggers113611933_muggers
nugget8311723_nugget_
nuggety1234313_nuggety
pluggers12297023pluggers
preggers12236833preggers
proggers12258163proggers
raggees93710913_raggees
reglets83512983_reglets
regrets83212923_regrets
riggers93613833_riggers
rugged94215373_rugge_d
rugger84414513_rugge_r
runlets73310773_runlets
russets738163_russets
sluggers10348483sluggers
smuggest1244373smuggest
snuggest1045233snuggest
suggest9310863_suggest
suggests1044713_suggests
thuggees1343123thuggees
triggers10257843triggers
triggest1036923triggest
trudgens10255143trudgens
trudgers10256853trudgers
trudges9339983trudge_s
trumpets12315573trumpets
tuggers93711443_tuggers

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621066.59322169.3
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.81226231.8
 
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.