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 “trumpery” 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
trumpery153361(None) 
thumper14356952thumper_
thumpers15365712thumpers
tramper113812162tramper_
trampers123210392trampers
trumped12439712trumpe_d
trumpet113810722trumpe_t
trumpets12315572trumpets
bumper123714343_bumper_
bumpers133912053_bumpers
crimper136510423crimper_
crimpers14318933crimpers
crumber13339643crumber_
crumbers14338243crumbers
crumped144311223crumpe_d
crumpet133711063crumpe_t
crumpets14335943crumpets
crumply16336093crump_ly
crupper13338563crupper_
cruppers14317323cruppers
drapery13387943dr_apery
drudgery14273633drudgery
drummer12407503drummer_
drummers13316163drummers
dumper114615213_dumper_
dumpers123412663_dumpers
dupery12378743_du_pery
empery1348683__empery
erumpent1245453erumpent
flummery1833053flummery
frippery1832953frippery
frumpier1534173frumpier_
frumpily1843323frumpily
frumpy16466883frump__y
grapery13457953gr_apery
grummer12338783grummer_
grumped13337333grumpe_d
grumphy18443623grump_hy
grumpier1334803grumpier_
grumpily1643463grumpily
grumpy14498153grump__y
humper134115883_humper_
humpers142713523_humpers
jumper173612373_jumper_
jumpers18399843_jumpers
lumper103816653_lumper_
lumpers113514483_lumpers
mummery13336663_mummery
mumper123513523_mumper_
mumpers133311373_mumpers
plumbery17315533plumbery
plumper13318773plumper_
plumpers14357293plumpers
prudery1335243pru_dery
pumper124415553_pumper_
pumpers133113673_pumpers
romper104213683_romper_
rompers113412243_rompers
ropery114313873_r_opery
rubbery14337593_rubbery
rudery10419033_ru_dery
rummer104715483_rummer_
rummers113513653_rummers
rumply13348573_rump_ly
slumbery15296043slumbery
strummer1234783strummer_
strummers1333693strummers
strumpet1256033strumpe_t
strumpets1362893strumpets
stumper113610093stumper_
stumpers12318313stumpers
summery14329413_summery
tamper104618513t_amper_
tampers113516743t_ampers
temper103914093t_emper_
tempera11329043t_empera
tempers113513013t_empers
thrummer1542933thrummer_
thrummers1642413thrummers
thuggery1642563thuggery
thumped15387413thumpe_d
thundery1533823thundery
timbery14256893t_imbery
tracery12399793tr_acery
tramped124312433trampe_d
trampier12318243trampier_
trampler12278013trampler_
tramplers13305883tramplers
trampy13499253tramp__y
trapper113912803trapper_
trappers123711043trappers
trickery17297343trickery
trimer85717153trim_er_
trimers94615143trim_ers
trimmer113610833trimmer_
trimmers12288913trimmers
tripper113711923tripper_
trippers123210163trippers
trompe105611263trompe__
tromped124210293trompe_d
trompes114111623trompe_s
trooper94210363trooper_
troopers10289443troopers
trouper93811433trouper_
troupers10359443troupers
truantry1142543truantry
trucker134010733trucker_
truckers14279013truckers
trudger9338733trudger_
trudgers10256863trudgers
truepenny1451513truepenny
truer54916643tru__er_
trumeau944163trum_eau
trump95615123trump___
trumperies1444453trumperies
trumpeted1443053trumpeted
trumpeter1343153trumpeter
trumpeters1442633trumpeters
trumping13308733trumping
trumps104611883trump__s
trusser74010263trusser_
trussers8348283trussers
truster73114313truster_
trusters83112263trusters
tumefy1434223t_um_efy
tumped114216233t_umpe_d
turnery10357423t_urnery
tushery1335633t_ushery

Search took 9 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.423422437.4
2DLD Change Limit1461621287.71618942.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.18521831.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.