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

382 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
swappers1535808(None) 
sappers113518901s_appers
slappers123710941slappers
snappers123510171snappers
swampers15317471swampers
swapper14359701swapper_
cappers134419402_cappers
clappers143310832clappers
crappers144011022crappers
flappers15388382flappers
knappers16315642knappers
lappers113717462_lappers
mappers133313782_mappers
nappers114214862_nappers
rappers113618442_rappers
sapper103822352s_apper_
scalpers123710862scalpers
scampers143611032scampers
scarpers124712512scarpers
scaupers12378172scaupers
scrappers1545862scrappers
scuppers1446542scuppers
shapers124016892sha_pers
sharpers133810942sharpers
shippers153012312shippers
shoppers153010762shoppers
sippers113117752s_ippers
skippers16318202skippers
slapper113512462slapper_
slippers123711232slippers
snapper113512072snapper_
snippers12299722snippers
soapers93715922soa_pers
stampers124211602stampers
staplers103111202staplers
steppers12289282steppers
stoppers123910592stoppers
strappers1346742strappers
suppers113314702s_uppers
swabbers15316742swabbers
swagers114211022swa_gers
swaggers13407222swaggers
swamper14349312swamper_
swapped15429142swappe_d
swarmers1346322swarmers
swashers14389532swashers
swathers144512082swathers
swatters113911792swatters
swayers13398852swa_yers
sweepers13348162sweepers
swoopers13317522swoopers
tappers113416542_tappers
trappers123711042trappers
warpers123413582_warpers
whappers18276742whappers
wrappers15306932wrappers
yappers144012252_yappers
zappers203911632_zappers
adapters1136103adapters
apers76629133__a_pers
appears11308953__appears
appels104312793__appels
aspers86220313__aspers
awaiters1146643awaiters
awarders1245073awarders
boppers133911923_boppers
campers134220293_campers
capers105428143_ca_pers
capper124421983_capper_
carpers114521253_carpers
champers173311623champers
chapters154012133chapters
chippers173510883chippers
choppers174110463choppers
clampers143211893clampers
clapper134011863clapper_
claspers124410913claspers
clippers14368843clippers
coappears1542953coappears
coppers133519753_coppers
crapper133913193crapper_
croppers143311483croppers
cruppers14317323cruppers
cuppers133712213_cuppers
dampers123915693_dampers
dapper114016633_dapper_
diapers104713913dia_pers
didappers1543173didappers
dippers123615183_dippers
drapers105313353dra_pers
drippers13327943drippers
droppers13318603droppers
escapers12337413esca_pers
flapper14359203flapper_
flippers15338003flippers
floppers15337463floppers
frappes14328383frappe_s
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
gippers123212083_gippers
grapplers14274303grapplers
graspers11338403graspers
grippers13358133grippers
gyppers15235503_gyppers
hampers143616953_hampers
happens14359173_happens
harpers124916203_harpers
heapers123616673hea_pers
hoppers143115143_hoppers
japers154616173_ja_pers
jaspers164310463_jaspers
kippers153211433_kippers
knapper15387153knapper_
lampers113817333_lampers
lapper104319953_lapper_
lappets11329123_lappets
lapsers93911053_lapsers
leapers93716663lea_pers
lippers113416443_lippers
loppers113014103_loppers
mapper124516093_mapper_
moppers133412463_moppers
napper103718283_napper_
nappes104515623_nappe_s
nippers113012623_nippers
pampers133615933_pampers
papers105125323_pa_pers
paupers114311073_paupers
peppers103311443_peppers
poppers103414863_poppers
quippers2184813quippers
rapers84327183_ra_pers
rapiers95012873_rapiers
rappees113611453_rappees
rappels11448803_rappels
rapper104621573_rapper_
raspers94415923_raspers
reapers93520453rea_pers
reappears1342853reappears
repapers1258833repapers
rippers114115033_rippers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
samplers12299403samplers
sanders84025943s_anders
sangers84421943s_angers
sapiens9310173s_apiens
sapless93313443s_apless
sapors84118813s_a_pors
sapours93610623s_apours
sapped114422013s_appe_d
sappier113613113s_appier_
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scalers93817263sca_lers
scalpels12345883scalpels
scalper113912923scalper_
scammers14339773scammers
scamper134613163scamper_
scanners10379703scanners
scapes105122263sca_pe_s
scarers94618513sca_rers
scarfers13408463scarfers
scarper114814823scarper_
scatters103612753scatters
scauper11379453scauper_
scepters1237793scepters
schappes1736033schappe_s
schnappers1942143schnappers
scoopers124210193scoopers
scrapers125510533scrapers
scrapper1466973scrapper_
scupper1367423scupper_
sealers74323553sea_lers
seamers94719433sea_mers
seaters74028943sea_ters
shaders115915553sha_ders
shakers144015563sha_kers
shammers153710843shammers
shaper114119933sha_per_
shapes115124943sha_pe_s
sharers104720623sha_rers
sharkers154011053sharkers
sharpens13377813sharpens
sharper124312703sharper_
shatters113313913shatters
shavers134115093sha_vers
shippens15316803shippens
shipper143514043shipper_
shopper143312633shopper_
shoppes143411393shoppe_s
simpers113014123s_impers
sipper103920993s_ipper_
sippets113310183s_ippets
skankers11316483skankers
skaters113512963ska_ters
skipper15339573skipper_
skippets16284563skippets
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slanders94014013slanders
slapped123511843slappe_d
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
sleepers103110113sleepers
slipper113712983slipper_
slippery15275863slippery
slopers94213093s_lopers
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snapless10287463snapless
snapped124611203snappe_d
snappier1266213snappier_
snarers74216663sna_rers
snarlers8298753snarlers
snipers93311773s_nipers
snipper113911333snipper_
snippets12225623snippets
snoopers10319843snoopers
soakers114114953soa_kers
soaper84517873soa_per_
soapier93411713soapier_
soapless10278073soapless
soarers74118093soa_rers
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammers14378693spammers
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
speers85019953s__peers
spiers84421743s__piers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stammers123611523stammers
stamper113714403stamper_
standers93514303standers
stapes85028733sta_pe_s
stapler93913633stapler_
staples93617213staple_s
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
steepers103011373steepers
stepper113010853stepper_
steppes113110693steppe_s
stipplers1334453stipplers
stompers123610043stompers
stoopers103711303stoopers
stopers94217373s_topers
stopper113012603stopper_
strapper1258093strapper_
stripers103911593stripers
strippers1355773strippers
stroppers1356713stroppers
stumpers12318313stumpers
sumpters1238023sumpters
supers84622403s__upers
supper104115433s_upper_
swabber14297963swabber_
swager104013613swa_ger_
swages104417073swa_ge_s
swagger12389333swagger_
swales93920763swa_le_s
swamies123712063swamie_s
swamped15498443swampe_d
swampier1544593swampier_
swamps135910263swamp__s
swanherd1533483swanherd
swanherds1642543swanherds
swanker14369483swanker_
swannery1433553swannery
swanpans1343423swanpans
swapping16348673swapping
swaps104819203swa_p__s
swarmer1247803swarmer_
swasher134011513swasher_
swashes134714403swashe_s
swather134213603swather_
swathes134115513swathe_s
swatter104113323swatter_
swayer125210973swa_yer_
swearers11328583swearers
sweaters113811063sweaters
sweeper12329373sweeper_
swelters113110193swelters
swervers1455213swervers
swifters14277483swifters
swiggers13337123swiggers
swillers11299113swillers
swimmers15276693swimmers
swingers123710423swingers
swipes114114333sw_ipe_s
swiples12339643swiple_s
swipples1534843swipples
swishers14328053swishers
swithers144310533swithers
swobbers15355593swobbers
swooners11336863swooners
swooper12389173swooper_
swopped15437673swoppe_d
swotters11448483swotters
syphers15317273s_yphers
tampers113516743_tampers
tapers84025813_ta_pers
tapper104419613_tapper_
tappets113610013_tappets
tippers113414353_tippers
toppers113914603_toppers
trampers123210393trampers
trapper113912803trapper_
trippers123210163trippers
twangers12226063twangers
uppers102912293__uppers
vampers143111623_vampers
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
wanders114221333_wanders
wankers144514713_wankers
wanters104420093_wanters
wapped144416473_wappe_d
warders113416813_warders
warmers124514293_warmers
warners103315563_warners
warper114015583_warper_
washers134517523_washers
wasters104026593_wasters
waters95030633_wa_ters
wavers125022473_wa_vers
waxers164014303_wa_xers
weepers123511973_weepers
whapper17348273whapper_
whippers18329043whippers
whoppers18297533whoppers
wipers115416083_w_ipers
wrapper14368333wrapper_
yapper133714513_yapper_
yaupers12337663_yaupers
yawpers15346853_yawpers
zapper193414023_zapper_
zippers203310383_zippers

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 Filter1786911461620.440406115.9
2DLD Change Limit1461623827.14020470.9
3Display Results3823820.1562448.7
 (SQL Overall)1786913827.73623098.6
 
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.