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 “bedbugs” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
bedbugs1319350(None) 
bedbug12193971bedbug_
bedrugs11194281bedrugs
redbugs11134461redbugs
bedaubs1233692bedaubs
bedrug10164952bedrug_
debugs10467822de_bugs
mudbugs1342852mudbugs
redbuds11144282redbuds
redbug10165472redbug_
babuls105413643b_abuls
babus95620333b_abu_s
barbuts11439843barbuts
beadings123711783beadings
beanbags1342863beanbags
bearhugs1442533bearhugs
beaus75127113be_au_s
beauts86015283be_auts
bebops1237623be_bops
beclogs1237073beclogs
bedamns1235733bedamns
bedaub1146033bedau_b
bedders113513383bedders
beddings13407923beddings
bedecks1635793bedecks
bedells10379363bedells
bedels94015273bed_els
bedews12398943bed_ews
bedims1149593bed_ims
bedlams1237053bedlams
bedless1039703bedless
bedouin1046043bedouin
bedouins1145513bedouins
bedpans1237173bedpans
beds75937783bed___s
bedsits1037563bedsits
bedu75923693bed_u__
beduin939713bed_uin
beduins1039123beduins
bedumb1335063bed_umb
bedumbs1433633bedumbs
beebees1138013beebees
beflags1355493beflags
befogs1246453be_fogs
befouls1236053befouls
begs75733833be___gs
begums11429493be_gums
beings94613033be_ings
belauds1036643belauds
belongs10408223belongs
beluga936233be_luga
belugas1035903be_lugas
bergs84718043be__rgs
besmuts1134683besmuts
bestuds10326753bestuds
bewigs1246533be_wigs
billbugs1342703billbugs
bodings113711653bodings
bubus95115453b_ubu_s
bugs76035913___bugs
bulbuls11346783bulbuls
debags104211063de_bags
debug94210063de_bug_
debuts93911753de_buts
dorbugs1132983dorbugs
drugs75214653__drugs
dugs614832283__d_ugs
feedbags1592733feedbags
goldbugs1342103goldbugs
humbugs1534243humbugs
ladybugs1541433ladybugs
mediums12308723mediums
medius93613283mediu_s
mudbug1243253mudbug_
rebus75721113re_bu_s
rebuts84015193re_buts
rebuys11428783re_buys
redbays1336013redbays
redbud10135803redbu_d
redlegs936823redlegs
redouts81411663redouts
redubs9358383red_ubs
seabags1037483seabags
sebums10369813se_bums
sedums93910483sed_ums
tediums10266973tediums
zebus164610053ze_bu_s

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.406440125.6
2DLD Change Limit134027876.62620227.4
3Display Results87870.0302900.0
 (SQL Overall)178691877.06225303.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.