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

68 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
thrummers164241(None) 
thrummer1542931thrummer_
drummers13316162_drummers
hummers143813062_h_ummers
rummers113513652__rummers
strummers1333692strummers
thrummed1642842thrumme_d
thrummier1641792thrummier_
thrusters1245332thrusters
thumpers15365712th_umpers
trimmers12288912t_rimmers
brimmers14287073_brimmers
bummers133712443__bummers
crammers14369353_crammers
crimmers14298543_crimmers
crumbers14338243_crumbers
cummers133713483__cummers
drummer12407503_drummer_
grummer12338783_grummer_
grummets13275033_grummets
gummers123712203__gummers
hammers144216063_h_ammers
hemmers143310843_h_emmers
hummer133615273_h_ummer_
humpers142713523_h_umpers
krimmers16315673_krimmers
mummers103712843__mummers
rammers113715043__rammers
rimmers113812883__rimmers
rummer104715483__rummer_
scummers14277783_scummers
shammers153710843sh_ammers
shimmers15269413sh_immers
shrimpers1633813shrimpers
slummers12358933_slummers
strummer1234783strummer_
summers113616503__summers
termers95414503ter__mers
thrashers1565313thrashers
threaders1365743threaders
threapers1444773threapers
threshers1545423threshers
thrillers1244473thrillers
thrivers14456823thr_ivers
throbbers1643173throbbers
throwers14106033thr_owers
thrummiest1742093thrummiest
thrumming1742903thrumming
thrummy1742173thrumm__y
thrums11429123thru_m__s
thrushes1436523thrushe_s
thruster1135793thruster_
thrustors1244303thrustors
thumper14356953th_umper_
thunders1236953th_unders
thurifers1542913thurifers
trammels12295413t_rammels
trampers123210393t_rampers
trimers94615143t_r_imers
trimmer113610833t_rimmer_
trommels12254333t_rommels
truckers14279013t_ruckers
trudgers10256863t_rudgers
trumpery1533613t_rumpery
trumpets12315573t_rumpets
trussers8348283t_russers
trusters83112263t_rusters
tummlers12295703t__ummlers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641687.11020905.9
3Display Results68680.0302266.7
 (SQL Overall)178691687.56323627.0
 
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.