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

128 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
bedaubs123369(None) 
bedaub1146031bedaub_
beaus75127112be_au_s
beauts86015282be_auts
bedamns1235732bedamns
bedaubed1443182bedaubed
bedbugs13193502bedbugs
bedrugs11194282bedrugs
bedumbs1433632bedumbs
belauds1036642belauds
daubs85014562__daubs
redubs9358382red_ubs
babus95620333b__abus
badass949293bada_ss
barbs95928193b__arbs
bauds85821043b__auds
beaders104120183beaders
beadles103414723beadles
beads85429503be_a_ds
beaks115326623be_a_ks
beams95328173be_a_ms
beanos85516513be_anos
beans75734693be_a_ns
beards94116673be_ards
bears75739043be_a_rs
beasts84519723be_asts
beats76042243be_a_ts
beau66137273be_au__
beauish12268513be_auish
beaut75135213be_au_t
beauty115410163be_auty
beaux146513213be_au_x
becalms1335743becalms
becaps123811403beca_ps
because1136233because
bedabble1243703bedabble
bedabbles1343043bedabbles
bedamn1137813beda_mn
bedaubing1553193bedaubing
bedbug12193973bedbu_g
bedders113513383bedders
bedecks1635793bedecks
bedells10379363bedells
bedels94015273bed_els
bedews12398943bed_ews
bedims1149593bed_ims
bedlamps1543663bedlamps
bedlams1237053bedlams
bedless1039703bedless
bedmates1349183bedmates
bedouin1046043bedouin
bedouins1145513bedouins
bedpans1237173bedpans
bedrails1136293bedrails
bedrapes1386963bedrapes
bedrug10164953bedru_g
beds75937783bed___s
bedsits1037563bedsits
bedu75923693bed_u__
beduin939713bed_uin
beduins1039123beduins
bedumb1335063bed_umb
bedwards1596393bedwards
bedwarfs17113583bedwarfs
befalls12349123befalls
befouls1236053befouls
begalls10319163begalls
begazes1937963begazes
begums11429493be_gums
behaves15198523behaves
belaud939133belau_d
belays114313853bela_ys
beldames1336803beldames
beldams1237053belda_ms
bemas96424283bema__s
benames112814603benames
bendays13327513benda_ys
benumbs1333543benumbs
berakes134815773berakes
berates94126853berates
besmuts1134683besmuts
bestuds10326753bestuds
betakes134212523betakes
betas75528763beta__s
bewails1277553bewails
bewares12313373bewares
bezants1877343bezants
bicarbs1336013bicarbs
blabs95619633b_la_bs
blubs95818153b__lubs
brewpubs174873brewpubs
bubs86235503b___ubs
cedars93312833ceda_rs
dabs77139403__da_bs
darbs85323263__darbs
daub77423443__daub_
daube85015303__daube
daubes94913703__daubes
dauby115211223__dauby
dauts67822243__dauts
dedans85915073deda_ns
degauss933923degauss
drubs85913833__drubs
dubs78432193__d_ubs
kebabs14418513keba_bs
medakas1435763medakas
medals94218043meda_ls
mediums12308723mediums
medius93613283mediu_s
padauks1443943padauks
pedalos10329683pedalos
pedals94316033peda_ls
pedants10310113pedants
redacts10510943redacts
redans75421023reda_ns
redates83423863redates
redbuds11144283redbuds
redbugs11134463redbugs
redoubt10167843redoubt
redoubts11153973redoubts
redouts81411653redouts
redub84212413red_ub_
rehabs1139023reha_bs
sedans74816093seda_ns
sedates83418033sedates
sedums93910483sed_ums
serdabs1035323serda_bs
tediums10266973tediums

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 Limit1340271287.23318529.9
3Display Results1281280.0304266.7
 (SQL Overall)1786911287.41924085.6
 
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.