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

517 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
swapper1435970(None) 
sapper103822351s_apper
slapper113512461slapper
snapper113512071snapper
swamper14349311swamper
swapped15429141swapped
swappers15358081swappers
capper124421982_capper
clapper134011862clapper
crapper133913192crapper
dapper114016632_dapper
flapper14359202flapper
knapper15387152knapper
lapper104319952_lapper
mapper124516092_mapper
napper103718282_napper
rapper104621572_rapper
sapped114422012s_apped
sappers113518902s_appers
sappier113613112s_appier
scalper113912922scalper
scamper134613162scamper
scarper114814822scarper
scauper11379452scauper
scrapper1466972scrapper
scupper1367422scupper
shaper114119932sha_per
sharper124312702sharper
shipper143514042shipper
shopper143312632shopper
sipper103920992s_ipper
skipper15339572skipper
slapped123511842slapped
slappers123710942slappers
slipper113712982slipper
snapped124611202snapped
snappers123510172snappers
snappier1266212snappier
snipper113911332snipper
soaper84517872soa_per
soapier93411712soapier
stamper113714402stamper
stapler93913632stapler
stepper113010852stepper
stopper113012602stopper
strapper1258092strapper
supper104115432s_upper
swabber14297962swabber
swager104013612swa_ger
swagger12389332swagger
swamped15498442swamped
swampers15317472swampers
swampier1544592swampier
swanker14369482swanker
swarmer1247802swarmer
swasher134011512swasher
swather134213602swather
swatter104113322swatter
swayer125210972swa_yer
sweeper12329372sweeper
swooper12389172swooper
swopped15437672swopped
tapper104419612_tapper
trapper113912802trapper
wapped144416472_wapped
warper114015582_warper
whapper17348272whapper
wrapper14368332wrapper
yapper133714512_yapper
zapper193414022_zapper
adapter1036173adapter
aper66336233__a_per
appear10379343__appear
appel94615893__appel
apter76120203__apter
asper75520433__asper
awaiter1057443awaiter
awarder1135893awarder
bopper123813833_bopper
camper124722213_camper
caper94831623_ca_per
capped134721853_capped
cappers134419403_cappers
carper104923633_carper
champer163813413champer
chapped172711443chapped
chapter144213853chapter
chipper163912583chipper
chopper163611893chopper
clamper134012993clamper
clapped143511173clapped
clappers143310833clappers
clasper113811863clasper
clipper133710323clipper
coappear1442893coappear
copper124321893_copper
crapped143912623crapped
crappers144011023crappers
crappier14288133crappier
cropper133312963cropper
crupper13338563crupper
cupper124313863_cupper
damper114117753_damper
dapped124516763_dapped
diaper94513113dia_per
didapper1442953didapper
dipper114017793_dipper
draper94315693dra_per
dripper12349233dripper
dropper12329873dropper
dwarfer1433683dwarfer
escaper11368843esca_per
flapped15328253flapped
flappers15388383flappers
flappier1544293flappier
flipper14389143flipper
flopper14328473flopper
frappe13286953frappe_
frapped15318853frapped
frappes14328383frappes
gaper86125123_ga_per
gapped124217123_gapped
gappier12369843_gappier
gasper94515543_gasper
gawper12499693_gawper
gipper114215303_gipper
grapier103712603grapier
grappler13336193grappler
grasper10389793grasper
gripper124410713gripper
gypper14347293_gypper
hamper134518653_hamper
happed144820103_happed
happen134812193_happen
happier143312033_happier
harper115018403_harper
heaper114119523hea_per
hepper133412663_hepper
hipper133818023_hipper
hopper134218483_hopper
japer146218883_ja_per
jasper154610383_jasper
kipper143414213_kipper
knapped16397103knapped
knappers16315643knappers
lapped114320033_lapped
lappers113717463_lappers
lappet103817723_lappet
lapser84113143_lapser
leaper88118943lea_per
lipper104219633_lipper
lopper103717203_lopper
mapped134015883_mapped
mappers133313783_mappers
mopper126215003_mopper
nappe96114993_nappe_
napped114218163_napped
nappers114214863_nappers
nappes104515623_nappes
nappier114411173_nappier
nipper103715713_nipper
pamper124316663_pamper
paper95128663_pa_per
pappier103511593_pappier
pauper103511943_pauper
pepper93512943_pepper
popper93615963_popper
quipper2095823quipper
raper74932753_ra_per
rapier84019993_rapier
rapped114122683_rapped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rappers113618443_rappers
rasper83917333_rasper
reaper84223143rea_per
reappear1242623reappear
repaper11310023repaper
ripper103518653_ripper
saber75330243s_a_ber
sacker125124843s_acker
sadder82916973s_adder
safer84721813s_a_fer
sager65432053s_a_ger
sagger84321073s_agger
sagier73717163s_agier
sailer63526103s_ailer
saker95132023s_a_ker
salter64325083s_alter
salver94617753s_alver
sampler113212013sampler
sander74828533s_ander
saner54334323s_a_ner
sanger74524563s_anger
sapor75119253s_a_por
sapour83812373s_apour
sappy125413473s_app_y
saucer84314103s_aucer
sauger74316253s_auger
saver84831253s_a_ver
sawer85026213s_a_wer
sawyer12438043s_awyer
sayer84926553s_a_yer
scaler84321603sca_ler
scalier94316913scalier
scalped124411993scalped
scalpel11377713scalpel
scalpers123710863scalpers
scammer133611973scammer
scamped144711963scamped
scampers143611033scampers
scanner94411813scanner
scanter94215183scanter
scape96921843sca_pe_
scaped115519553sca_ped
scapes105122263sca_pes
scarcer113911373scarcer
scarer84524613sca_rer
scarfer124511083scarfer
scarier94017873scarier
scarped124314403scarped
scarpers124712513scarpers
scatter93815173scatter
scaupers12378173scaupers
scepter1138363scepter
schappe1635263schappe_
schappes1736033schappes
schnapper1842473schnapper
scooper113812033scooper
scraper114513423scraper
scrapped1556533scrapped
scrappers1545863scrappers
scrappier1544423scrappier
scuppers1446543scuppers
sealer63928963sea_ler
seamer84223613sea_mer
seamier93114633seamier
searer65432023sea_rer
seater64534163sea_ter
seepier92912013seepier
shader104218763sha_der
shadier113111153shadier
shaker134319463sha_ker
shakier143411153shakier
shalier103116423shalier
shammer144613143shammer
shape105125113sha_pe_
shaped125020103sha_ped
shapen114414653sha_pen
shapers124016893sha_pers
shapes115124943sha_pes
sharer95025483sha_rer
sharker144313813sharker
sharped134112053sharped
sharpen12389723sharpen
sharpers133810943sharpers
shatter103615703shatter
shaver123718913sha_ver
shipped153312103shipped
shippen14298863shippen
shippers153012313shippers
shoppe133110323shoppe_
shopped153512213shopped
shoppers153010763shoppers
shoppes143411393shoppes
simper103616293s_imper
simpler112910863simpler
sipped113720633s_ipped
sippers113117753s_ippers
sippet103519393s_ippet
skanker10268483skanker
skater105015493ska_ter
skipped16358413skipped
skippers16318203skippers
skippet15288463skippet
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slammer113913033slammer
slander84015443slander
slasher104515333slasher
slater64429183sla_ter
slather103816073slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
sleeper93211563sleeper
slipped124711743slipped
slippers123711233slippers
slippery15275863slippery
slippier1256533slippier
sloper84615913s_loper
slopped123511443slopped
sloppier1255703sloppier
smacker153410583smacker
smaller93410333smaller
smarter94113133smarter
smasher123911023smasher
smatter93613333smatter
snacker133112603snacker
snakier112810003snakier
snappy1366103snapp_y
snarer64620843sna_rer
snarler73610633snarler
sniper84413643s_niper
snipped123510043snipped
snippers12299723snippers
snippet113310433snippet
snippier1255793snippier
snooper93511533snooper
soaker105717533soa_ker
soaped95817973soa_ped
soapers93715923soa_pers
soarer64522243soa_rer
sopped114819903s_opped
soppier112711583soppier
soupier93111753soupier
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spammer133410433spammer
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spatter94016523spatter
spawner12347363spawner
speer74623903s__peer
spier75728033s__pier
stabber113610153stabber
stabler94014933stabler
stacker134416263stacker
staffer13299093staffer
stager74821343sta_ger
stagger94212393stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823sta_ler
stalker113912253stalker
stammer116013343stammer
stamped124812813stamped
stampers124211603stampers
stander84316163stander
stapes85028733sta_pes
staple84415823staple_
stapled103613703stapled
staplers103111203staplers
staples93617213staples
starer64027363sta_rer
starker114114693starker
starter73817883starter
starver104611993starver
stater64427563sta_ter
stayer94516483sta_yer
steeper93812773steeper
steppe10319873steppe_
stepped123210053stepped
steppers12289283steppers
steppes113110693steppes
stippler1235543stippler
stomper114111233stomper
stooper93813193stooper
stoper84320103s_toper
stopped124512203stopped
stoppers123910593stoppers
strapped1357823strapped
strappers1346743strappers
strappier1345133strappier
striper94514793striper
stripper1247123stripper
stropper1247763stropper
stumper113610093stumper
suaver93014233sua_ver
sumpter1138873sumpter
super74924483s__uper
supped114415703s_upped
suppers113314703s_uppers
suppler1148433suppler
swabbed15367403swabbed
swabbers15316743swabbers
swacked173110523swacked
swage94919563swa_ge_
swaged114212253swa_ged
swagers114211023swa_gers
swages104417073swa_ges
swagged13419153swagged
swaggers13407223swaggers
swagmen1334973swagmen
swale85221593swa_le_
swales93920763swa_les
swamies123712063swamies
swamp125015323swamp__
swamps135910263swamp_s
swampy16437233swamp_y
swanherd1533483swanherd
swanked15359543swanked
swankier15225503swankier
swanned11358173swanned
swannery1433553swannery
swanpan1243693swanpan
swap95925433swa_p__
swapping16348673swapping
swaps104819203swa_p_s
swarded1238153swarded
sware85828213swa_re_
swarmed1367483swarmed
swarmers1346323swarmers
swashed144311363swashed
swashers14389533swashers
swashes134714403swashes
swathe125514113swathe_
swathed144611933swathed
swathers144512083swathers
swathes134115513swathes
swatted114110693swatted
swatters113911793swatters
swayed133510263swa_yed
swayers13398853swa_yers
swearer10349953swearer
sweater103712723sweater
sweatier1147033sweatier
sweepers13348163sweepers
sweepier1355493sweepier
sweer84918573sw__eer
sweeter103212003sweeter
sweller103012463sweller
swelter103711173swelter
swerver1365733swerver
swifter13318053swifter
swigger12338453swigger
swiller103211663swiller
swimmer14297653swimmer
swinger113812563swinger
swipe105217083sw_ipe_
swiped123811093sw_iped
swipes114114333sw_ipes
swiple11379233swiple_
swiples12339643swiples
swipple1444633swipple
swipples1534843swipples
swisher13369523swisher
swither133710993swither
swobber14336543swobber
swooner10358673swooner
swooped13418753swooped
swoopers13317523swoopers
swoopier13175143swoopier
swotter10399473swotter
sypher14317083s_ypher
tamper104618513_tamper
taper74829773_ta_per
tapped113820053_tapped
tappers113416543_tappers
tappet103820113_tappet
tipper103918413_tipper
topper103817603_topper
tramper113812163tramper
trapped124512213trapped
trappers123711043trappers
tripper113711923tripper
twanger11327433twanger
upper93714263__upper
vamper134212653_vamper
wacker154920123_wacker
wadder114215483_wadder
wader95325363_wa_der
wafer114417643_wa_fer
wafter124114613_wafter
wager95925053_wa_ger
wagger113616013_wagger
wailer93720323_wailer
waiter94321253_waiter
waiver124212713_waiver
waker125526593_wa_ker
waler84229263_wa_ler
walker133913993_walker
wander104423713_wander
wanier93920683_wanier
wanker134219973_wanker
wanner94019623_wanner
wanter94423053_wanter
warder104020273_warder
warier93722893_warier
warmer113816733_warmer
warner93717223_warner
warped124816413_warped
warpers123413583_warpers
washer124720393_washer
waspier12259053_waspier
waster95228943_waster
water84733313_wa_ter
watter93221983_watter
waver115025703_wa_ver
wavier124613083_wavier
waxer154317483_wa_xer
waxier16439903_waxier
weeper114313303_weeper
whapped18367573whapped
whappers18276743whappers
whipper173611383whipper
whopper17328503whopper
wiper105421293_w_iper
wrapped15338023wrapped
wrappers15306933wrappers
yapped144415143_yapped
yappers144012253_yappers
yauper11368543_yauper
yawper14437953_yawper
zapped204213523_zapped
zappers203911633_zappers
zappier20458373_zappier
zipper193813123_zipper

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340275175.84322938.0
3Display Results5175170.1862779.6
 (SQL Overall)1786915176.43527768.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.