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

474 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
trampers12321039(None) 
tampers113516741t_ampers
tramper113812161tramper_
tramplers13305881tramplers
trappers123711041trappers
campers134220292_campers
champers173311622champers
clampers143211892clampers
crammers14369352crammers
crappers144011022crappers
crimpers14318932crimpers
dampers123915692_dampers
drapers105313352dra_pers
framers125113822fram_ers
graspers11338402graspers
hampers143616952_hampers
lampers113817332_lampers
pampers133615932_pampers
rammers113715042_rammers
rapers84327182_ra_pers
rappers113618442_rappers
raspers94415922_raspers
rompers113412242_rompers
scampers143611032scampers
stampers124211602stampers
strappers1346742strappers
swampers15317472swampers
tamers84224032t_am_ers
tamper104618512t_amper_
tapers84025812t_a_pers
tappers113416542t_appers
tempers113513012t_empers
thumpers15365712thumpers
tracers94917842tra_cers
trackers143512852trackers
traders84316952tra_ders
trailers82912922trailers
trainers83114642trainers
tramcars1245232tramcars
tramels93812492tram_els
tramless1037502tramless
trammels12295412trammels
tramped124312432trampe_d
trampier12318242trampier_
trampler12278012trampler_
tramples122610202tramples
tramps105114452tramp__s
trapes85024462tra_pe_s
trapper113912802trapper_
trashers113013642trashers
trawlers113310202trawlers
trimers94615142trim_ers
trimmers12288912trimmers
trippers123210162trippers
trompes114111622trompe_s
troopers10289442troopers
troupers10359442troupers
trumpery1533612trumpery
trumpets12315572trumpets
vampers143111622_vampers
wrappers15306932wrappers
abampere1442853abampere
abamperes1563023abamperes
ambers104519583__ambers
ameers84015573__ameers
ampere10514413__ampere
amperes11313983__amperes
apers76629133__a_pers
arames84622573aram_e_s
armers85520273ar_m_ers
aspers86220313__aspers
attempers13103503attempers
blamers115314213blam_ers
bracers114616703bra_cers
braggers12327903braggers
braiders114110573braiders
branders114313093branders
branners104010923branners
brasiers103710513brasiers
bravers124715523bra_vers
brawlers13408643brawlers
brayers124511903bra_yers
brazers184513943bra_zers
braziers19397193braziers
brimmers14287073brimmers
bumpers133912053_bumpers
cambers134017443_cambers
camper124722213_camper_
capers105428143_ca_pers
cappers134419403_cappers
carpers114521253_carpers
chambers173410623chambers
chamfers18409223chamfers
champer163813413champer_
chompers17369593chompers
clambers144211293clambers
clammers143510693clammers
clamper134012993clamper_
clappers143310833clappers
claspers124410913claspers
crabbers14358753crabbers
crackers164111723crackers
cradlers11309203cradlers
crafters13419953crafters
crambes1339963crambe_s
crammer134010963crammer_
cramped144712183crampe_d
crampier14288903crampier_
crampits1436273crampits
crampons1436643crampons
cramps125615563cramp__s
crapes104727693cra_pe_s
crapper133913193crapper_
crashers134013233crashers
craters95021893cra_ters
cravers124416563cra_vers
crawlers13309013crawlers
creamers124111313cream_ers
creepers12318633creepers
crimmers14298543crimmers
crimper136510423crimper_
crispers12309433crispers
croppers143311483croppers
crumbers14338243crumbers
crumpets14335943crumpets
cruppers14317323cruppers
dammers123214273_dammers
damners104112113_damners
dampens12348563_dampens
damper114117753_damper_
diapers104713913dia_pers
drafters12338533drafters
draggers11357393draggers
drainers92811253drainers
draper94315693dra_per_
drapery13387943dra_pery
drapes95419653dra_pe_s
drawers113610073dra_wers
drawlers12307313drawlers
dreamers11369003dream_ers
drippers13327943drippers
droppers13318603droppers
drummers13316163drummers
dumpers123412663_dumpers
entrappers1444183entrappers
erasers74413943era_sers
farmers124315263farm_ers
flamers124616363flam_ers
flappers15388383flappers
foamers123812103foam_ers
framer114817443fram_er_
frames115119863fram_e_s
frankers15348353frankers
frappes14328383frappe_s
fraters103517213fra_ters
gamers94420833_gam_ers
gammers123214563_gammers
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
grabbers13337883grabbers
graders94716013gra_ders
grafters12409193grafters
grainers93012073grainers
grammars13345943grammars
grammes123611323gramme_s
grampas12399253gramp_as
gramps114114273gramp__s
grampus12356313gramp_us
grangers103011973grangers
granters93614143granters
grapery13457953gra_pery
grapes95123123gra_pe_s
grapplers14274303grapplers
grasper10389793grasper_
graters85419743gra_ters
graupels1133103graupels
gravers114515273gra_vers
grazers175112453gra_zers
graziers18387123graziers
gripers104011463gr_ipers
grippers13358133grippers
gropers104813853gr_opers
groupers11358643groupers
hammers144216063_hammers
hamper134518653_hamper_
harmers124116593harm_ers
harpers124916203_harpers
heapers123616673hea_pers
humpers142713523_humpers
jammers183710703_jammers
japers154616173_ja_pers
jaspers164310463_jaspers
jumpers18399843_jumpers
knappers16315643knappers
kraters114212343kra_ters
krimmers16315673krimmers
lambers113817113_lambers
lappers113717463_lappers
leapers93716663lea_pers
limpers113815223_limpers
lumpers113514483_lumpers
mammers104615693_mammers
mamzers20409163_mamzers
mappers133313783_mappers
mumpers133311373_mumpers
namers84517333_nam_ers
nappers114214863_nappers
ormers84316143or_m_ers
pamper124316663_pamper_
pampero13328093_pampero
pamperos14306693_pamperos
papers105125323_pa_pers
paupers114311073_paupers
plumpers14357293plumpers
praisers103410833praisers
prancers123210333prancers
praters94921653pra_ters
prawners1346003prawners
prayers124212853pra_yers
premiers122911653premiers
primers114215673prim_ers
prompters1537553prompters
propers113619033pr_opers
prospers123012263prospers
pumpers133113673_pumpers
racers84725433_ra_cers
rackers134320453_rackers
rafters103715633_rafters
raiders84615143_raiders
railers74420663_railers
raisers73617393_raisers
rakers104123573_ra_kers
ramblers124010373_ramblers
ramees84620893_ram_ees
ramets83517393_ram_ets
ramies84630463_ramie_s
ramjets1635163_ramjets
rammer103519653_rammer_
rampagers1443863_rampagers
rampart11311993_rampart
ramparts1245583_ramparts
ramped114617903_rampe_d
ramps96224633_ramp__s
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
raper74932753_ra_per_
rapes75740723_ra_pe_s
rapiers95012873_rapiers
rappees113611453_rappees
rappels11448803_rappels
rapper104621573_rapper_
rasers64526783_ra_sers
rashers104020913_rashers
rasper83917333_rasper_
rasters74629023_rasters
raters63936583_ra_ters
ratters74422473_ratters
ravers94628183_ra_vers
razers154919613_ra_zers
reamers94221083ream_ers
reapers93520453_reapers
revampers1653443revampers
rimers84522553_rim_ers
rimmers113812883_rimmers
rippers114115033_rippers
roamers93713463roam_ers
romper104213683_romper_
ropers84325903_r_opers
rummers113513653_rummers
samplers12299403_samplers
sappers113518903_sappers
scalpers123710863scalpers
scammers14339773scammers
scamper134613163scamper_
scarpers124712513scarpers
scaupers12378173scaupers
scrapers125510533scra_pers
scrappers1545863scrappers
scrimpers1554643scrimpers
seamers94719433seam_ers
shammers153710843shammers
shapers124016893sha_pers
sharpers133810943sharpers
shrimpers1633813shrimpers
simpers113014123_simpers
slammers123511223slammers
slappers123710953slappers
snappers123510173snappers
soapers93715923soa_pers
spammers14378693spammers
stammers123611523stammers
stamper113714403stamper_
steamers103410873steam_ers
stompers123610043stompers
strafers11379913stra_fers
strainers9510383strainers
stranders10389933stranders
strangers104112163strangers
strapper1258093strapper_
strayers113510143stra_yers
streamers11228073stream_ers
stripers103911593str_ipers
strippers1355773strippers
stroppers1356713stroppers
strummers1333693strummers
strumpets1362893strumpets
stumpers12318313stumpers
swamper14349313swamper_
swappers15358083swappers
tabers84621573t_a_bers
tackers134319623t_ackers
taggers93514193t_aggers
tailers73720183t_ailers
takers103923743t_a_kers
talers64628143t_a_lers
talkers113513213t_alkers
tamburs11288613t_amburs
tamer75230103t_am_er_
tames75242013t_am_e_s
tampans113310983t_ampans
tamped114317043t_ampe_d
tampered13279463t_ampered
tamperer12248893t_amperer
tamperers13227313t_amperers
tampons112711563t_ampons
tamps95524083t_amp__s
tankers113416913t_ankers
tanners74018393t_anners
taper74829773t_a_per_
tapes75838603t_a_pe_s
tapirs84113173t_a_pirs
tapper104419613t_apper_
tappets113610013t_appets
tarpapers1344273tarpapers
tarriers83411713tarriers
tarsiers8298533tarsiers
tasters74225643t_asters
taters64932203t_a_ters
tatters74520483t_atters
taupes8212673t_aupe_s
tawers94118603t_a_wers
taxers134015283t_a_xers
teachers133212393teachers
teamakers1544873teamakers
teamsters1135973teamsters
tearers75218233tea_rers
teasers75317243tea_sers
teemers95012903teem_ers
tempehs14325153t_empehs
temper103914093t_emper_
tempera11329043t_empera
temperas12278233t_emperas
tempters12257293t_empters
termers95414503term_ers
tetramers1146463tetram_ers
thalers106212263tha_lers
thankers15297833thankers
thawers13428483tha_wers
thrashers1565313thrashers
threapers1444773threapers
thrummers1642413thrummers
thumper14356953thumper_
timbers113111853t_imbers
timers84420993t_im_ers
tippers113414353t_ippers
toasters83912723toasters
topers85025323t__opers
toppers113914603t_oppers
tracer84820233tra_cer_
tracery12399793tra_cery
traces85329933tra_ce_s
tracheas13410273tracheas
tracker133515173tracker_
tractors10312573tractors
trader75218763tra_der_
trades75724503tra_de_s
traducers1243723traducers
trailer73015393trailer_
trainees82712063trainees
trainer73316793trainer_
traipses1036873traipses
traitors8310793traitors
tramcar1135593tramcar_
tramel84113713tram_e_l
tramell9398703tram_ell
tramells10327833tramells
trammed123810713tramme_d
trammel11357663tramme_l
trammelers1442513trammelers
tramp96319773tramp___
trampiest13227903trampiest
tramping132711273tramping
trampish1535653trampish
trample11299703tramp_le
trampled13247903trampled
trampy13499253tramp__y
trams75327673tram___s
tramways1643723tramways
trances93919643trance_s
transfers1238053transfers
trapans92812463tra_pans
trapeses1039153tra_peses
trapeze1836253tra_peze
trapezes1936543tra_pezes
trappean1244393trappean
trapped124512213trappe_d
trappous1246023trappous
traps75727483tra_p__s
trasher104416133trasher_
trashes104119263trashe_s
trasses74819323trasse_s
travelers12266773travelers
travels104711293tra_vels
traverse1136213tra_verse
traves94222743tra_ve_s
trawler104011903trawler_
trawleys14284383trawleys
treaders93311843treaders
treadlers1045893treadlers
treaters83615843treaters
trekkers1133803trekkers
tremblers1334483tremblers
tremors93711233trem_ors
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613493trillers
trimer85717153trim_er_
trimeters1139213trimeters
trimmer113610833trimmer_
trimness1067563trimness
tripes85324873tr_ipe_s
tripper113711923tripper_
trippets12357423trippets
troffers14125433troffers
trollers83211213trollers
trommels12254333trommels
trompe105611263trompe__
tromped124210293trompe_d
tromps104911703tromp__s
trooper94210363trooper_
tropes84824353tr_ope_s
trotters83310243trotters
trouper93811433trouper_
troupes94112853troupe_s
trousers83910633trousers
trovers103713323tr_overs
trowsers11428003trowsers
truckers14279013truckers
trudgers10256863trudgers
trumped12439713trumpe_d
trumperies1444453trumperies
trumpet113810723trumpe_t
trumpeters1442633trumpeters
trumps104611883trump__s
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
tummlers12295703tummlers
twangers12226063twangers
vamper134212653_vamper_
warmers124514293warm_ers
warpers123413583_warpers
whappers18276743whappers
whimpers18276613whimpers
wrapper14368333wrapper_
yammers143410323_yammers
yappers144012253_yappers
yaupers12337663_yaupers
yawpers15346853_yawpers
zappers203911633_zappers

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.593301333.9
2DLD Change Limit1461624747.67019056.3
3Display Results4744740.1902494.7
 (SQL Overall)1786914748.45321139.4
 
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.