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

394 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
swampers1531747(None) 
scampers143611031scampers
stampers124211601stampers
swamper14349311swamper_
swappers15358081swappers
campers134220292_campers
champers173311622champers
clampers143211892clampers
dampers123915692_dampers
hampers143616952_hampers
lampers113817332_lampers
pampers133615932_pampers
samplers12299402s_amplers
sappers113518902s_appers
scalpers123710862scalpers
scammers14339772scammers
scamper134613162scamper_
scarpers124712512scarpers
scaupers12378172scaupers
seamers94719432seam_ers
shammers153710842shammers
shapers124016892sha_pers
sharpers133810942sharpers
simpers113014122s_impers
slammers123511222slammers
slappers123710942slappers
snappers123510172snappers
soapers93715922soa_pers
spammers14378692spammers
stammers123611522stammers
stamper113714402stamper_
stompers123610042stompers
stumpers12318312stumpers
swabbers15316742swabbers
swagers114211022swa_gers
swaggers13407222swaggers
swamies123712062swamie_s
swamped15498442swampe_d
swampier1544592swampier_
swamps135910262swamp__s
swapper14359702swapper_
swarmers1346322swarmers
swashers14389532swashers
swathers144512082swathers
swatters113911792swatters
swayers13398852swa_yers
sweepers13348162sweepers
swimmers15276692swimmers
swoopers13317522swoopers
tampers113516742_tampers
trampers123210392trampers
vampers143111622_vampers
warpers123413582_warpers
abampere1442853abampere
abamperes1563023abamperes
ambers104519583__ambers
ameers84015573__ameers
ampere10514413__ampere
amperes11313983__amperes
apers76629133__a_pers
aspers86220313__aspers
awaiters1146643awaiters
awarders1245073awarders
blamers115314213blam_ers
bumpers133912053_bumpers
cambers134017443_cambers
camper124722213_camper_
capers105428143_ca_pers
cappers134419403_cappers
carpers114521253_carpers
chambers173410623chambers
chamfers18409223chamfers
champer163813413champer_
chompers17369593chompers
clambers144211293clambers
clammers143510693clammers
clamper134012993clamper_
clappers143310833clappers
claspers124410913claspers
crammers14369353crammers
crappers144011023crappers
crimpers14318933crimpers
dammers123214273_dammers
damners104112113_damners
dampens12348563_dampens
damper114117753_damper_
diapers104713913dia_pers
drapers105313353dra_pers
dumpers123412663_dumpers
escapers12337413esca_pers
flamers124616363flam_ers
flappers15388383flappers
foamers123812103foam_ers
framers125113823fram_ers
gamers94420833_gam_ers
gammers123214563_gammers
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
graspers11338403graspers
hammers144216063_hammers
hamper134518653_hamper_
harpers124916203_harpers
heapers123616673hea_pers
humpers142713523_humpers
jammers183710703_jammers
japers154616173_ja_pers
jaspers164310463_jaspers
jumpers18399843_jumpers
knappers16315643knappers
lambers113817113_lambers
lappers113717463_lappers
leapers93716663lea_pers
limpers113815223_limpers
lumpers113514483_lumpers
mammers104615693_mammers
mamzers20409163_mamzers
mappers133313783_mappers
mumpers133311373_mumpers
namers84517333_nam_ers
nappers114214863_nappers
pamper124316663_pamper_
pampero13328093_pampero
pamperos14306693_pamperos
papers105125323_pa_pers
paupers114311073_paupers
plumpers14357293plumpers
pumpers133113673_pumpers
rammers113715043_rammers
rapers84327183_ra_pers
rappers113618443_rappers
raspers94415923_raspers
reamers94221083ream_ers
reapers93520453rea_pers
revampers1653443revampers
roamers93713463roam_ers
rompers113412243_rompers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sambars115113843s_ambars
samburs11369343s_amburs
sameks12409323s_am_eks
samiels939763s_amiels
samlets93813553s_amlets
sampans112411003s_ampans
sampler113212013s_ampler_
samples112815453s_amples
samps96124673s_amp__s
sanders84025943s_anders
sangers84421943s_angers
sapors84118813s_a_pors
sapper103822353s_apper_
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scalers93817263sca_lers
scalpels12345883scalpels
scalper113912923scalper_
scammer133611973scammer_
scamped144711963scampe_d
scampered1635233scampered
scamperer1544623scamperer
scamperers1643473scamperers
scampies1439323scampies
scamps125014173scamp__s
scamsters1334993scamsters
scanners10379703scanners
scapes105122263sca_pe_s
scarers94618513sca_rers
scarfers13408463scarfers
scarper114814823scarper_
scatters103612753scatters
scauper11379453scauper_
schmeers1574833schmeers
scoopers124210193scoopers
scrapers125510533scrapers
scrappers1545863scrappers
scrimpers1554643scrimpers
scummers14277783scummers
scuppers1446543scuppers
sealers74323553sea_lers
seamer84223613seam_er_
seamier93114633seamier_
seamless10238723seamless
seamsters1136333seamsters
seaters74028943sea_ters
seemers93814333seem_ers
shaders115915553sha_ders
shakers144015563sha_kers
shames114726223sham_e_s
shammer144613143shammer_
shammes144312833shamme_s
shampooers1742493shampooers
shampoos1544603shampoos
shaper114119933sha_per_
shapes115124943sha_pe_s
sharers104720623sha_rers
sharkers154011053sharkers
sharpens13377813sharpens
sharper124312703sharper_
shatters113313913shatters
shavers134115093sha_vers
shimmers15269413shimmers
shippers153012313shippers
shoppers153010763shoppers
shrimpers1633813shrimpers
simmers113314613s_immers
simper103616293s_imper_
sippers113117753s_ippers
skankers11316483skankers
skaters113512963ska_ters
skimmers16296463skimmers
skippers16318203skippers
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammer113913033slammer_
slanders94014013slanders
slapper113512463slapper_
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
sleepers103110113sleepers
slimmers12369633slimmers
slippers123711233slippers
slopers94213093s_lopers
slumbers123110273slumbers
slummers12358933slummers
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snapper113512073snapper_
snarers74216663sna_rers
snarlers8298753snarlers
snipers93311773s_nipers
snippers12299723snippers
snoopers10319843snoopers
soakers114114953soa_kers
soaper84517873soa_per_
soarers74118093soa_rers
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammer133410433spammer_
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stamens93411483stam_ens
stammels12495563stammels
stammer116013343stammer_
stamped124812813stampe_d
stampede13326163stampede
stampeders15233203stampeders
stampedes14315183stampedes
stampless1334543stampless
stamps105614023stamp__s
standers93514303standers
stapes85028733sta_pe_s
staplers103111203staplers
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
steamers103410873steam_ers
steepers103011373steepers
stemmers12378443stemmers
steppers12289283steppers
stomper114111233stomper_
stoopers103711303stoopers
stopers94217373s_topers
stoppers123910593stoppers
strappers1346743strappers
stripers103911593stripers
stumper113610093stumper_
summers113616503s_ummers
sumpters1238023s_umpters
supers84622403s__upers
suppers113314703s_uppers
swabber14297963swabber_
swager104013613swa_ger_
swages104417073swa_ge_s
swagger12389333swagger_
swales93920763swa_le_s
swamis114212293swam__is
swamp125015323swamp___
swampiest1635023swampiest
swampiness1773353swampiness
swamping16307923swamping
swampish1844173swampish
swampy16437233swamp__y
swanherd1533483swanherd
swanherds1642543swanherds
swanker14369483swanker_
swannery1433553swannery
swanpans1343423swanpans
swapped15429143swappe_d
swaps104819203swa_p__s
swarmer1247803swarmer_
swasher134011513swasher_
swashes134714403swashe_s
swather134213603swather_
swathes134115513swathe_s
swatter104113323swatter_
swayer125210973swa_yer_
swearers11328583swearers
sweaters113811063sweaters
sweeper12329373sweeper_
swelters113110193swelters
swervers1455213swervers
swifters14277483swifters
swiggers13337123swiggers
swillers11299113swillers
swimmer14297653swimmer_
swingers123710423swingers
swipes114114333sw_ipe_s
swishers14328053swishers
swithers144310533swithers
swobbers15355593swobbers
swooners11336863swooners
swooper12389173swooper_
swotters11448483swotters
tamers84224033_tam_ers
tamper104618513_tamper_
tapers84025813_ta_pers
tappers113416543_tappers
tempers113513013_tempers
thumpers15365713thumpers
tramper113812163tramper_
tramplers13305883tramplers
trappers123711043trappers
twangers12226063twangers
vamper134212653_vamper_
wadders123812443_wadders
waders109120643_wa_ders
wafers124316143_wa_fers
wafters134112813_wafters
wagers105122203_wa_gers
waggers124613083_waggers
wailers103916803_wailers
waiters104218623_waiters
waivers133410053_waivers
wakers134822493_wa_kers
walers94824463_wa_lers
walkers143411473_walkers
wames106432803_wam_e_s
wampums16314213_wampums
wampus13499013_wamp_us
wanders114221333_wanders
wankers144514713_wankers
wanters104420093_wanters
warders113416813_warders
warmers124514293_warmers
warners103315563_warners
warper114015583_warper_
washers134517523_washers
wasters104026593_wasters
waters95030633_wa_ters
wavers125022473_wa_vers
waxers164014303_wa_xers
weepers123511973_weepers
whappers18276743whappers
whimpers18276613whimpers
wipers115416083_w_ipers
wrappers15306933wrappers
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.406440125.6
2DLD Change Limit1461623947.59319249.6
3Display Results3943940.1602462.5
 (SQL Overall)1786913948.15921901.1
 
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.