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

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

54 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
drumbeaters165184(None) 
drumbeater1552031drumbeater_
drumbeats1442322drumbeat__s
crabeaters1444503cr_abeaters
drumbeat1343973drumbeat___
drumbeating1752073drumbeating
drumbeatings185983drumbeatings
dumbwaiters195963d_umbwaiters
trumpeters1442633trumpe_ters
adumbrates1553134adumbrate_s
beaters94925044____beaters
combaters1538114_comb_aters
crabeater1345594cr_abeater_
crumbers14338244crumb___ers
cumberers15176004_cumbe_rers
cupbearers1642134_cupbearers
debaters113511924d__eb_aters
defeaters13289104d__efeaters
diameters1247594diam_e_ters
dimeters11411094d_im_e_ters
documenters1652814docum_enters
doubters11257394dou_b__ters
dreamers11369004dr___eamers
drubbers13386034dru_b__bers
drugmakers1841804dru_gmakers
drumbles13277724drumb__le_s
drumheads1642294drumhea__ds
drummers13316164drum___mers
dumbcanes1672774d_umbcane_s
dumbwaiter1851064d_umbwaiter_
dumpsters1453744d_um_psters
durometers1356374durome_ters
eggbeaters1451524_eggbeaters
furbearers1552724_furbearers
grumblers14245024grumb__lers
lumberers13196014_lumbe_rers
numberers13165154_numbe_rers
orometers11310424orom_e_ters
preheaters1557194pr_eheaters
rebaters103413944_r_eb_aters
reheaters122010274_r_eheaters
repeaters112811994_r_epeaters
retreaters1047544_retreaters
rimesters1137484_rim_esters
rumblers123610744_rumb__lers
ruminates11410194_ruminate_s
ruminators1286064_ruminators
rummagers1443034_rum_magers
slumberers14203684slumbe_rers
treaters83615844tr___eaters
trimesters1245414trim_esters
trimeters1139214trim_e_ters
trumpeter1343154trumpe_ter_
upbearers1343034__upbearers

Search took 10 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 Filter1786911488190.1701051123.5
2DLD Change Limit148819549.58015534.3
3Display Results54540.0301800.0
 (SQL Overall)178691549.78018271.1
 
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.