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

523 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
swamper1434931(None) 
scamper134613161scamper
stamper113714401stamper
swamped15498441swamped
swampers15317471swampers
swampier1544591swampier
swapper14359701swapper
camper124722212_camper
champer163813412champer
clamper134012992clamper
damper114117752_damper
hamper134518652_hamper
pamper124316662_pamper
sampler113212012s_ampler
sapper103822352s_apper
scalper113912922scalper
scammer133611972scammer
scamped144711962scamped
scampers143611032scampers
scarper114814822scarper
scauper11379452scauper
seamer84223612seam_er
seamier93114632seamier
shammer144613142shammer
shaper114119932sha_per
sharper124312702sharper
simper103616292s_imper
slammer113913032slammer
slapper113512472slapper
snapper113512072snapper
soaper84517872soa_per
spammer133410432spammer
stammer116013342stammer
stamped124812812stamped
stampers124211602stampers
stomper114111232stomper
stumper113610092stumper
swabber14297962swabber
swager104013612swa_ger
swagger12389332swagger
swamies123712062swamies
swamp125015322swamp__
swamps135910262swamp_s
swampy16437232swamp_y
swanker14369482swanker
swapped15429142swapped
swappers15358082swappers
swarmer1247802swarmer
swasher134011512swasher
swather134213602swather
swatter104113322swatter
swayer125210972swa_yer
sweeper12329372sweeper
swimmer14297652swimmer
swooper12389172swooper
tamper104618512_tamper
tramper113812162tramper
vamper134212652_vamper
warper114015582_warper
abampere1442853abampere
amber94523213__amber
ameer75618983__ameer
amped104820513__amped
ampere10514413__ampere
ampler104313303__ampler
aper66336233__a_per
asper75520433__asper
awaiter1057443awaiter
awarder1135893awarder
beamier113411943beamier
blamer104417143blam_er
bumper123714343_bumper
camber124418483_camber
camped134720233_camped
campers134220293_campers
campier133313273_campier
caper94831623_ca_per
capper124421983_capper
carper104923633_carper
chamber164011063chamber
chamfer17399863chamfer
champed174111483champed
champers173311623champers
chomper163810073chomper
clamber133311743clamber
clammer134211793clammer
clamped144012043clamped
clampers143211893clampers
clapper134011863clapper
clasper113811863clasper
crammer134010963crammer
cramped144712183cramped
crampier14288903crampier
crapper133913193crapper
crimper136510423crimper
dammer114317933_dammer
damner95213433_damner
damped124315583_damped
dampen114310593_dampen
dampers123915693_dampers
dapper114016633_dapper
diaper94513113dia_per
draper94315693dra_per
dumper114615213_dumper
dwarfer1433683dwarfer
escaper11368843esca_per
flamer114919123flam_er
flamier123112143flamier
flapper14359203flapper
foamer114714313foam_er
foamier12339003foamier
framer114817443fram_er
gamer84928943_gam_er
gamier93617933_gamier
gammer1112318333_gammer
gaper86125123_ga_per
gasper94515543_gasper
gawper12499693_gawper
grasper10389793grasper
hammer138120033_hammer
hampers143616953_hampers
harper115018403_harper
heaper114119523hea_per
humper134115883_humper
jammer174014133_jammer
japer146218883_ja_per
jasper154610383_jasper
jimper17389863_jimper
jumper173612373_jumper
knapper15387153knapper
lamber104418493_lamber
lamer75233703_lam_er
lamped114017543_lamped
lampers113817333_lampers
lapper104319953_lapper
leaper88118943lea_per
limper104117853_limper
loamier9349163loamier
lumper103816653_lumper
mammer94218863_mammer
mamzer19459833_mamzer
mapper124516093_mapper
mumper123513523_mumper
namer75622103_nam_er
napper103718283_napper
pampero13328093_pampero
pampers133615933_pampers
paper95128663_pa_per
pauper103511943_pauper
plumper13318773plumper
pumper124415553_pumper
rammer103519653_rammer
ramped114617903_ramped
raper74932753_ra_per
rapper104621573_rapper
rasper83917333_rasper
reamer84325213ream_er
reaper84223143rea_per
revamper1533533revamper
roamer84715163roam_er
romper104213683_romper
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
sambar103914163s_ambar
sambur10469503s_ambur
same65245643s_am_e_
samek114915273s_am_ek
samiel8313333s_amiel
samlet84126563s_amlet
samp85733593s_amp__
sampan102511893s_ampan
sample104215013s_ample
sampled123410793s_ampled
samplers12299403s_amplers
samples112815453s_amples
samps96124673s_amp_s
sander74828533s_ander
saner54334323s_a_ner
sanger74524563s_anger
sapor75119253s_a_por
sapped114422013s_apped
sappers113518903s_appers
sappier113613123s_appier
saucer84314103s_aucer
sauger74316253s_auger
saver84831253s_a_ver
sawer85026213s_a_wer
sawyer12438043s_awyer
sayer84926553s_a_yer
scaler84321603sca_ler
scalier94316913scalier
scalped124411993scalped
scalpel11377713scalpel
scalpers123710863scalpers
scammed14479543scammed
scammers14339773scammers
scamp115717313scamp__
scampered1635233scampered
scamperer1544623scamperer
scampi12469103scamp_i
scampies1439333scampies
scamps125014173scamp_s
scamster1235303scamster
scanner94411813scanner
scanter94215183scanter
scape96921843sca_pe_
scaped115519553sca_ped
scapes105122263sca_pes
scarcer113911373scarcer
scarer84524613sca_rer
scarfer124511083scarfer
scarier94017873scarier
scarped124314403scarped
scarpers124712513scarpers
scatter93815173scatter
scaupers12378173scaupers
schmeer1475363schmeer
scooper113812033scooper
scraper114513423scraper
scrapper1466973scrapper
scrimper1455763scrimper
scummer13398753scummer
scupper1367423scupper
sealer63928963sea_ler
seamed94823883seam_ed
seamen84518563seam_en
seamers94719433seam_ers
seamster1037143seamster
searer65432023sea_rer
seater64534163sea_ter
seemer84418043seem_er
sempre102710093s_empre
shader104218763sha_der
shadier113111153shadier
shaker134319463sha_ker
shakier143411153shakier
shalier103116423shalier
shame105726703sham_e_
shamed125120213sham_ed
shames114726223sham_es
shammed153911423shammed
shammers153710843shammers
shammes144312833shammes
shampoo1435373shampoo
shampooer1643063shampooer
shape105125113sha_pe_
shaped125020103sha_ped
shapen114414653sha_pen
shapers124016893sha_pers
shapes115124953sha_pes
sharer95025483sha_rer
sharker144313813sharker
sharped134112053sharped
sharpen12389723sharpen
sharpers133810943sharpers
shatter103615703shatter
shaver123718913sha_ver
shimmer143310873shimmer
shipper143514043shipper
shopper143312633shopper
shrimper1544413shrimper
simmer104115353s_immer
simpers113014123s_impers
simpler112910863s_impler
sipper103920993s_ipper
skanker10268483skanker
skater105015493ska_ter
skimmer15327533skimmer
skimped16256223skimped
skimpier1634293skimpier
skipper15339573skipper
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slammed123511103slammed
slammers123511223slammers
slander84015443slander
slapped123511853slapped
slappers123710953slappers
slasher104515333slasher
slater64429183sla_ter
slather103816073slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
sleeper93211563sleeper
slimier93212013slimier
slimmer114211343slimmer
slipper113712983slipper
sloper84615913s_loper
slumber113811003slumber
slummer113711203slummer
slumped123710153slumped
smacker153410583smacker
smaller93410333smaller
smarmier1235033smarmier
smarter94113133smarter
smasher123911023smasher
smatter93613333smatter
snacker133112603snacker
snakier112810003snakier
snapped124611203snapped
snappers123510173snappers
snappier1266223snappier
snarer64620843sna_rer
snarler73610633snarler
sniper84413643s_niper
snipper113911333snipper
snooper93511533snooper
soaker105717533soa_ker
soaped95817973soa_ped
soapers93715923soa_pers
soapier93411713soapier
soarer64522243soa_rer
somber103714003s_omber
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spammed14348523spammed
spammers14378693spammers
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spatter94016523spatter
spawner12347363spawner
spumier1137903spumier
stabber113610153stabber
stabler94014933stabler
stacker134416263stacker
staffer13299093staffer
stager74821343sta_ger
stagger94212393stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823sta_ler
stalker113912253stalker
stamen84115943stam_en
stammel11607533stammel
stammers123611523stammers
stamp95217363stamp__
stampede13326163stampede
stampeder14304343stampeder
stamps105614023stamp_s
stander84316163stander
stapes85028733sta_pes
stapler93913633stapler
starer64027363sta_rer
starker114114693starker
starter73817883starter
starver104611993starver
stater64427563sta_ter
stayer94516483sta_yer
steamer93313093steam_er
steamier1048303steamier
steeper93812773steeper
stemmer113210183stemmer
stepper113010853stepper
stomped124110533stomped
stompers123610043stompers
stooper93813193stooper
stoper84320103s_toper
stopper113012603stopper
strapper1258093strapper
striper94514793striper
stumped124210153stumped
stumpers12318313stumpers
stumpier1255883stumpier
suaver93014233sua_ver
summer104017713s_ummer
sumpter1138873s_umpter
super74924483s__uper
supper104115433s_upper
swabbed15367403swabbed
swabbers15316743swabbers
swacked173110523swacked
swage94919563swa_ge_
swaged114212253swa_ged
swagers114211023swa_gers
swages104417073swa_ges
swagged13419153swagged
swaggers13407223swaggers
swagmen1334973swagmen
swale85221593swa_le_
swales93920763swa_les
swam96329983swam___
swami105614523swam__i
swamis114212293swam_is
swampiest1635033swampiest
swamping16307923swamping
swampish1844173swampish
swamy136714403swam__y
swanherd1533483swanherd
swanked15359543swanked
swankier15225503swankier
swanned11358173swanned
swannery1433553swannery
swanpan1243693swanpan
swap95925433swa_p__
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
sweller103012473sweller
swelter103711173swelter
swerver1365733swerver
swifter13318053swifter
swigger12338453swigger
swiller103211663swiller
swimmers15276693swimmers
swimmier15174313swimmier
swimwear1641673swimwear
swinger113812563swinger
swipe105217083sw_ipe_
swiped123811093sw_iped
swipes114114333sw_ipes
swisher13369523swisher
swither133710993swither
swobber14336543swobber
swooner10358673swooner
swooped13418753swooped
swoopers13317523swoopers
swoopier13175143swoopier
swopped15437673swopped
swotter10399473swotter
tamer75230103_tam_er
tamped114317043_tamped
tampers113516743_tampers
taper74829773_ta_per
tapper104419613_tapper
temper103914093_temper
thumper14356953thumper
tramped124312433tramped
trampers123210393trampers
trampier12318243trampier
trampler12278013trampler
trapper113912803trapper
twanger11327433twanger
vamped144211013_vamped
vampers143111623_vampers
vampier14308233_vampier
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
wame95035483_wam_e_
wames106432803_wam_es
wampum15406053_wampum
wampus13499013_wampus
wander104423713_wander
wanier93920683_wanier
wanker134219973_wanker
wanner94019623_wanner
wanter94423053_wanter
wapped144416473_wapped
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
whapper17348273whapper
whimper17297723whimper
wimped144211513_wimped
wimpier14248053_wimpier
wiper105421293_w_iper
wrapper14368333wrapper
yammer133713183_yammer
yapper133714513_yapper
yauper11368543_yauper
yawper14437953_yawper
zapper193414023_zapper

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 Limit1340275235.75023309.0
3Display Results5235230.1862811.8
 (SQL Overall)1786915236.34228175.8
 
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.