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

134 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
bedrugs1119428(None) 
bedbugs13193501bedbugs
bedrug10164951bedrug_
bearhugs1442532bearhugs
bedaubs1233692bedaubs
bedbug12193972bedbug_
bergs84718042be_r_gs
drugs75214652__drugs
redbugs11134462redbugs
aerugo735803ae_rugo
aerugos834923ae_rugos
beadings123711783beadings
beards94116673bear_ds
bearers94619593bearers
bearhug1343163bearhug_
bearings113912253bearings
bears75739043bear__s
beaus75127113be_au_s
beauts86015283be_auts
beclogs1237073beclogs
becrust1137983becrust
becrusts1244843becrusts
bedamns1235733bedamns
bedaub1146033bedau_b
bedders113513383bedders
beddings13407923beddings
bedecks1635793bedecks
bedells10379363bedells
bedels94015273bed_els
bedews12398943bed_ews
bedims1149593bed_ims
bedlams1237053bedlams
bedless1039703bedless
bedouin1046043bedouin
bedouins1145513bedouins
bedpans1237173bedpans
bedrail1037253bedrail
bedrails1136293bedrails
bedrape1277693bedrape
bedrapes1386963bedrapes
bedrid1039943bedr_id
bedrock1645643bedrock
bedrocks1745333bedrocks
bedroll1055553bedroll
bedrolls1144673bedrolls
bedroom1247083bedroom
bedrooms1345713bedrooms
bedrugged1542313bedrugged
beds75937783bed___s
bedsits1037563bedsits
bedu75923693bed_u__
beduin939713bed_uin
beduins1039123beduins
bedumb1335063bed_umb
bedumbs1433633bedumbs
beers75628393beer__s
beflags1355493beflags
befogs1246453be_fogs
befouls1236053befouls
befrets1237613befrets
begrims1276763begrims
begrudge1362343begrudge
begrudges1472363begrudges
begs75733833be___gs
begums11429493be_gums
beings94613033be_ings
belauds1036643belauds
belongs10408223belongs
beluga936233be_luga
belugas1035903be_lugas
berets85822523be_rets
berg75425543be_r_g_
berks115423123be_r_ks
bermes106023003be_rmes
berms95323663be_r_ms
berries94423553berries
berths114712423be_rths
beryls11107883be_ryls
besmuts1134683besmuts
bestuds10326753bestuds
betrays12127823betrays
bewigs1246533be_wigs
bewraps14135403bewraps
bewrays15145113bewrays
bodings113711653bodings
bourgs9459993bour_gs
brags85625103b__rags
brigs85823223b__rigs
brugh115414293b__rugh
brughs12509063b__rughs
bruts75922953b__ruts
bugs76035913b___ugs
burgs84924093b_ur_gs
debugs10467823de_bugs
defrags1236193defrags
drags75521113__drags
dregs76114863__dregs
drubs85913833__drubs
drug65718133__drug_
drums85415873__drums
dugs614832283__d_ugs
ecrus75113863_ecru_s
ergs55523813_e_r_gs
erugo6369853_e_rugo
erugos7347343_e_rugos
ferrums1265983ferrums
frugs96114283__frugs
mediums12308723mediums
medius93613283mediu_s
mudbugs1342853mudbugs
pedros9312183pedr_os
perdues103511333perdues
perdus93711273perdu_s
prodrugs1242483prodrugs
redbuds11144283redbuds
redbug10165473redbug_
redlegs936823redlegs
redouts81411663redouts
redraws11218473redraws
redress82511873redress
redries83721713redries
redubs9358383red_ubs
rerigs74014793re_rigs
reruns66413743re_runs
rugs56033683___rugs
sedums93910483sed_ums
serums83916303se_rums
sevruga1142223sevruga
sevrugas1242153sevrugas
shrugs10469163_shrugs
sprugs94010173_sprugs
tediums10266973tediums
trugs65516803__trugs
xerus12313333xe_ru_s

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.423422437.4
2DLD Change Limit1340271346.20321606.8
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.67226782.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.