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

96 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
drumbeating175206(None) 
drumbeatings185971drumbeatings
adumbrating1752403adumbrating
browbeating1952353browbeating
drumbeat1343973drumbeat___
drumbeater1552033drumbeat_er
drumbeaters1651843drumbeaters
drumbeats1442323drumbeat__s
drumbling1544033drumb__ling
grummeting1642453grumme_ting
rumbaing13185303_rumb_a_ing
ruminating1348143_ruminating
trumpeting1543563trumpe_ting
acuminating1645804acuminating
beating104326874____beating
bromating1439164brom__ating
brominating1696084brominating
combating16310154_comb_ating
creating113921954cr___eating
cremating14312194crem__ating
criminating1646854criminating
crumbing15267814crumb___ing
crumbling1655084crumb__ling
cumbering16108204_cumbe_ring
cumulating1546354_cumulating
deaminating1547974deaminating
debating123213734d__eb_ating
debeaking1735924d__ebeaking
defeating142311974d__efeating
deliberating1645124deliberating
delineating1346374delineating
demeaning1337244d_em_eaning
dementing13311044d_em_enting
deuterating1347274deuterating
disseating121111784d_isseating
documenting1753124docum_enting
dominating1449404d_ominating
doubting1237374dou_b__ting
dreading113712804dr___eading
dreaming124011064dr___eaming
drubbing14286054dru_b__bing
drumming14265784drum___ming
dueting93814394d_u__e_ting
duetting1047184d_u__etting
dumbing13319854d_umb___ing
enucleating1444554enucleating
enumerating1445004enumerating
eructating1345694eru_ctating
exuberating2144174exu_berating
frustrating1544264frustrating
fumigating1744654_fumigating
grommeting1642914gromme_ting
grumbling1544084grumb__ling
laureating1146394lau_reating
lumbering14117934_lumbe_ring
nauseating1144984nau_seating
nucleating1346934_nucleating
numbering14107004_numbe_ring
numerating1357234_numerating
outbeaming1546044_outbeaming
outbleating1444884_outbleating
outeating10814494_ou_teating
overbeating17410484overbeating
permeating1539924perm_eating
plummeting1742104plumme_ting
preheating16310724pr_eheating
pretreating1448894pretreating
probating14311184pr_ob_ating
procreating1647694procreating
rabbeting1445184_rabbe_ting
rebating112418344_r_eb_ating
recreating131214584_recreating
reheating132314914_r_eheating
remating112322414_rem__ating
remeeting12311434_rem_eeting
remelting12311704_rem_elting
repeating122618984_r_epeating
reseating102421534_r_eseating
retreating111414774_retreating
rhumbaing1742244rhumb_a_ing
rubbering1435704_rubbe_ring
ruinating1039594_ru_inating
rumbling131910104_rumb__ling
rummaging1543364_rum_maging
russeting1065324_russe_ting
russetting1184254_russetting
slumbering15105324slumbe_ring
sublating12310984_su_blating
summating1437944_sum_mating
treating92519614tr___eating
truncating1344234tru_ncating
umbering1399434__umbe_ring
unbearing1239354__unbearing
unbelting1237664__unbelting
unseating10713204__unseating
upbearing1435034__upbearing

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.1561145455.1
2DLD Change Limit148819968.95316622.2
3Display Results96960.0631523.8
 (SQL Overall)178691969.17219482.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.