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

238 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
thumpers1536571(None) 
humpers142713521_humpers
thumper14356951thumper_
bumpers133912052_bumpers
champers173311612champers
chompers17369572chompers
dumpers123412662_dumpers
hampers143616942_hampers
hummers143813062_hummers
humper134115882_humper_
jumpers18399842_jumpers
lumpers113514482_lumpers
mumpers133311362_mumpers
plumpers14357292plumpers
pumpers133113672_pumpers
stumpers12318312stumpers
tampers113516742t_ampers
tempers113513012t_empers
thrummers1642412thrummers
thumped15387412thumpe_d
thumps13449352thump__s
thunders1236942thunders
trampers123210372trampers
trumpery1533612trumpery
trumpets12315572trumpets
whimpers18276612whimpers
attempers13103503attempers
bummers133712443_bummers
bumper123714343_bumper_
campers134220283_campers
chambers173410613chambers
chamfers18409213chamfers
champer163813403champer_
cheepers15329013cheepers
chimers144515133chim_ers
chippers173510873chippers
chirpers15358133chirpers
chomper163810073chomper_
choppers174110453choppers
chudders15235553chudders
chuggers1554853chuggers
chukkers1633473chukkers
chumped17379493chumpe_d
chumps154313823chump__s
chunters133910893chunters
churners13316883churners
clampers143211883clampers
clumbers143910393clumbers
crimpers14318933crimpers
crumbers14338223crumbers
crumpets14335943crumpets
cruppers14317313cruppers
cumbers134515393_cumbers
cummers133713473_cummers
cuppers133712193_cuppers
dampers123915693_dampers
drummers13316163drummers
dumper114615213_dumper_
dupers94615603_du_pers
exhumers2043263exhum_ers
fumers113613383_fum_ers
gazumpers2341423gazumpers
gulpers10299003_gulpers
gummers123712193_gummers
hammers144216053_hammers
hamper134518653_hamper_
harpers124916203_harpers
heapers123616673_heapers
helpers123311853_helpers
hemmers143310843_hemmers
homers114821973_hom_ers
hoopers123616483_hoopers
hopers114222973_h_opers
hoppers143115143_hoppers
huggers124211593_huggers
hullers103616263_hullers
humblers15379803_humblers
humeri1138523_hum_eri
humerus1236913_hum_erus
hummer133615273_hummer_
humors11129633_hum_ors
humours1286413_humours
humped144015243_humpe_d
humphs16528163_hump_hs
humpier143110723_humpier_
humpless15226333_humpless
humps126322803_hump__s
humvees1534683_humvees
hungers114013303_hungers
hunkers143314333_hunkers
hunters103915723_hunters
hurlers103714323_hurlers
hurters103413633_hurters
huskers143510033_huskers
hypers144811913_h_ypers
inhumers1364823inhum_ers
jumper173612373_jumper_
lampers113817333_lampers
limpers113815223_limpers
lumbers113815913_lumbers
lumpens11298263_lumpens
lumper103816653_lumper_
mummers103712843_mummers
mumper123513523_mumper_
numbers113711243_numbers
pampers133615933_pampers
paupers114311073pau_pers
plumbers14418513plumbers
plumpens14304953plumpens
plumper13318773plumper_
pulpers114612283_pulpers
pumper124415553_pumper_
rhymers15365543rhym_ers
rompers113412243_rompers
rummers113513653_rummers
scampers143611033scampers
scummers14277783scummers
scuppers1446533scuppers
shammers153710833shammers
shapers124016893sh_apers
sharpers133810943sharpers
shimmers15269413shimmers
shippers153012303shippers
shoppers153010753shoppers
shrimpers1633813shrimpers
shuckers17388133shuckers
shudders13316643shudders
shunners11317743shunners
shunters113210733shunters
shushers14267053shushers
shutters113611333shutters
simpers113014113_simpers
slumbers123110273slumbers
slummers12358933slummers
stampers124211593stampers
stompers123610033stompers
strummers1333693strummers
strumpets1362893strumpets
stumper113610093stumper_
summers113616503_summers
sumpters1238023_sumpters
supers84622403_su_pers
suppers113314693_suppers
swampers15317473swampers
tamers84224033t_am_ers
tamper104618513t_amper_
tapers84025813t__apers
tappers113416543t_appers
taunters8259263taunters
taupes8212673tau_pe_s
teemers95012903teem_ers
tempehs14325153t_empehs
temper103914093t_emper_
tempera11329043t_empera
temperas12278233t_emperas
tempters12257293t_empters
termers95414503term_ers
thalers106212263th_alers
thankers15297833thankers
thawers13428483th_awers
theaters114211893theaters
themes115319253them_e_s
thinkers15308693thinkers
thinners11327743thinners
thorpes125010353thorpe_s
threapers1444773threapers
thrivers14456823thrivers
throwers14106023throwers
thrummer1542933thrummer_
thrusters1245313thrusters
thuggees1343123thuggees
thuggery1642563thuggery
thumbed15336173thumbe_d
thumbless1643423thumbless
thumbs13377443thum__bs
thump126211573thump___
thumping16296713thumping
thunder1136963thunder_
thundery1533823thundery
thurifers1542913thurifers
thymes144810743thym_e_s
thymier1534393thymier_
timbers113111843t_imbers
timers84420993t_im_ers
tippers113414343t_ippers
topers85025323t__opers
toppers113914603t_oppers
touchers133611203touchers
toupees938513tou_pees
tourers73512733tou_rers
touters74018333tou_ters
tramper113812153tramper_
tramplers13305873tramplers
trappers123711023trappers
trimers94615143trim_ers
trimmers12288913trimmers
trippers123210153trippers
trompes114111623trompe_s
troopers10289423troopers
troupers10359423troupers
truckers14279003truckers
trudgers10256853trudgers
trumped12439713trumpe_d
trumperies1444453trumperies
trumpet113810723trumpe_t
trumpeters1442623trumpeters
trumps104611883trump__s
trussers8348263trussers
trusters83112243trusters
tubbers113411243t_ubbers
tubers85017023t_u_bers
tuckers134014353t_uckers
tufters10298343t_ufters
tuggers93711443t_uggers
tumblers123110623t_umblers
tummlers12295703tummlers
tumors8810603t_um_ors
tumours976733t_umours
tumped114216233t_umpe_d
tumps95420793t_ump__s
tuners64417343t_u_ners
turners73912893t_urners
tuskers113710033t_uskers
tussers74313563t_ussers
tuyers94612563t_u_yers
umbers104215213__umbers
uppers102912283__uppers
usurpers1033733usurpers
vampers143111623_vampers
whappers18276743whappers
whimper17297723whimper_
whippers18329033whippers
whispers16266993whispers
whoopers16286263whoopers
whoppers18297533whoppers
whumped18335633whumpe_d
whumps16427093whump__s
yaupers12337663yau_pers

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.1561145455.1
2DLD Change Limit1461622388.05018156.8
3Display Results2382380.0932559.1
 (SQL Overall)1786912388.29921531.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.