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

93 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
thrummed164284(None) 
thrummer1542931thrummer
chummed17396442ch_ummed
drummed13306322_drummed
hummed144812672_h_ummed
scrummed1554312scrummed
strummed1344472strummed
thrummers1642412thrummers
thrummier1641792thrummier
thrummy1742172thrumm_y
thrusted1265222thrusted
thumbed15336172th_umbed
thumped15387412th_umped
trammed123810712t_rammed
trimmed12348932t_rimmed
trumped12439712t_rumped
brimmed14386783_brimmed
bummed134211723__bummed
chromed153510923chr_omed
chumped17379493ch_umped
crammed143710123_crammed
crumbed14378473_crumbed
crumped144311223_crumped
degummed1542603degummed
drammed13378073_drammed
drummer12407503_drummer
grummer12338783_grummer
grummet12298873_grummet
grumped13337333_grumped
gummed123811663__gummed
hammed144116973_h_ammed
hemmed144211463_h_emmed
hummer133615273_h_ummer
humped144015243_h_umped
mummed104411553__mummed
primmed14388853_primmed
rammed113117303__rammed
rimmed114812303__rimmed
rummer104715483__rummer
scrammed1555003scrammed
scummed14347913_scummed
shammed153911423sh_ammed
shimmed15338583sh_immed
shlumped1643443shlumped
shrimped1634213shrimped
shrugged1433673shrugged
slummed12359273_slummed
strummer1234783strummer
stummed12348553_stummed
summed114014043__summed
termed94816703ter__med
themed125912583th__emed
thoued10429003thou__ed
thralled1245803thralled
thrashed1555363thrashed
thrawed1435583thr_awed
threaded1366323threaded
threaped1454863threaped
threated1259203threated
threeped1454373threeped
threshed1535643threshed
thrilled1235493thrilled
thrived14458183thr_ived
throated1247923throated
throbbed1643163throbbed
throned115412173thr_oned
thronged13405333thronged
thrum104713633thru_m__
thrummiest1742093thrummiest
thrumming1742903thrumming
thrums11429123thru_m_s
thrushes1436523thrushes
thruster1135793thruster
thudded1333433th_udded
thumper14356953th_umper
thunked15386853th_unked
tommed113310143t__ommed
trammel11357663t_rammel
tramped124312433t_ramped
trimmer113610833t_rimmer
trommel11315363t_rommel
tromped124210293t_romped
truced95312053t_ru_ced
trucked143910813t_rucked
trudged10298043t_rudged
trued65117693t_ru__ed
trumpet113810723t_rumpet
trunked12358413t_runked
trussed84010033t_russed
trusted83412793t_rusted
tumped114216233t__umped
whammed18345133wh_ammed
whumped18335633wh_umped

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 Filter1786911461620.420425454.8
2DLD Change Limit146162937.11020557.2
3Display Results93930.0462021.7
 (SQL Overall)178691937.57623586.5
 
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.