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 “snapper” 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
snapper11351207(None) 
knapper15387151knapper
napper103718281_napper
sapper103822351s_apper
slapper113512461slapper
snapped124611201snapped
snappers123510161snappers
snappier1266211snappier
snipper113911321snipper
swapper14359701swapper
capper124421982_capper
clapper134011862clapper
crapper133913192crapper
dapper114016632_dapper
flapper14359202flapper
knapped16397102knapped
knappers16315642knappers
lapper104319952_lapper
mapper124516092_mapper
nappe96114992_nappe_
napped114218162_napped
nappers114214862_nappers
nappes104515622_nappes
nappier114411172_nappier
nipper103715712_nipper
rapper104621572_rapper
sapped114422012s_apped
sappers113518892s_appers
sappier113613112s_appier
scalper113912922scalper
scamper134613162scamper
scarper114814822scarper
scauper11379452scauper
schnapper1842472schnapper
scrapper1466952scrapper
scupper1367422scupper
shaper114119932sha_per
sharper124312702sharper
shipper143514032shipper
shopper143312622shopper
sipper103920982s_ipper
skipper15339562skipper
slapped123511842slapped
slappers123710932slappers
slipper113712972slipper
snacker133112602snacker
snakier112810002snakier
snappy1366102snapp_y
snarer64620842sna_rer
snarler73610632snarler
sniper84413642sn_iper
snipped123510042snipped
snippers12299712snippers
snippet113310432snippet
snippier1255792snippier
snooper93511532snooper
soaper84517872soa_per
soapier93411712soapier
stamper113714392stamper
stapler93913622stapler
stepper113010852stepper
stopper113012592stopper
strapper1258082strapper
supper104115432s_upper
swamper14349312swamper
swapped15429142swapped
swappers15358072swappers
tapper104419612_tapper
trapper113912792trapper
whapper17348272whapper
wrapper14368332wrapper
yapper133714512_yapper
zapper193414022_zapper
adapter1036173adapter
anaphor1245653anaphor
aper66336233__a_per
appear10379343__appear
appel94615893__appel
apter76120203__apter
asper75520433__asper
bopper123813833_bopper
camper124722213_camper
caper94831623_ca_per
capped134721853_capped
cappers134419403_cappers
carper104923633_carper
catnapper1562913catnapper
champer163813403champer
chapped172711443chapped
chapter144213853chapter
chipper163912583chipper
chopper163611893chopper
clamper134012993clamper
clapped143511173clapped
clappers143310833clappers
clasper113811863clasper
clipper133710323clipper
coappear1442883coappear
copper124321893_copper
crapped143912623crapped
crappers144011023crappers
crappier14288133crappier
cropper133312963cropper
crupper13338563crupper
cupper124313863_cupper
damper114117753_damper
dapped124516763_dapped
diaper94513113dia_per
didapper1442953didapper
dipper114017783_dipper
dognapper1542433dognapper
draper94315693dra_per
dripper12349223dripper
dropper12329873dropper
enabler9299363enabler
endpaper1343883endpaper
entrapper1344853entrapper
escaper11368843esca_per
flapped15328253flapped
flappers15388383flappers
flappier1544293flappier
flipper14389143flipper
flopper14328473flopper
frappe13286953frappe_
frapped15318853frapped
frappes14328383frappes
gaper86125123_ga_per
gapped124217123_gapped
gappier12369843_gappier
gasper94515543_gasper
gawper12499693_gawper
gipper114215303_gipper
gnawer10386953gna_wer
grapier103712603grapier
grappler13336193grappler
grasper10389783grasper
gripper124410713gripper
gunpaper1342623gunpaper
gypper14347293_gypper
hamper134518653_hamper
hanaper1237133hanaper
happed144820103_happed
happen134812193_happen
happier143312033_happier
harper115018403_harper
heaper114119523hea_per
hepper133412663_hepper
hipper133818023_hipper
hopper134218483_hopper
inaner62213533ina_ner
japer146218883_ja_per
jasper154610383_jasper
kidnapper1842013kidnapper
kipper143414203_kipper
knacker12307913knacker
knopped16355443knopped
lapped114320033_lapped
lappers113717463_lappers
lappet103817723_lappet
lapser84113143_lapser
leaper88118943lea_per
lipper104219633_lipper
lopper103717203_lopper
mapped134015883_mapped
mappers133313773_mappers
mopper126215003_mopper
nabber104913543_nabber
nagger84016123_nagger
nailer64119363_nailer
naiver94311353_naiver
namer75622103_na_mer
nape65230803_na_pe_
napery11489813_na_pery
napes74828463_na_pes
nappa98511863_napp_a
nappas105511613_nappas
nappie104112263_nappie
nappies114613393_nappies
nappy126312333_napp_y
natter64420743_natter
nipped113615853_nipped
nippers113012613_nippers
nippier11319833_nippier
onager739663ona_ger
pamper124316663_pamper
paper95128663_pa_per
pappier103511593_pappier
pauper103511943_pauper
pepper93512943_pepper
petnapper1242453petnapper
popper93615963_popper
quipper2095813quipper
raper74932753_ra_per
rapier84019993_rapier
rapped114122683_rapped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rappers113618443_rappers
rasper83917323_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
sandier84017843sandier
sandpaper14124283sandpaper
sandpiper14103523sandpiper
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
scarer84524603sca_rer
scarfer124511083scarfer
scarier94017873scarier
scarped124314393scarped
scarpers124712513scarpers
scatter93815173scatter
scaupers12378173scaupers
scepter1138353scepter
schappe1635263schappe_
schappes1736033schappes
schnappers1942143schnappers
scooper113812033scooper
scraper114513403scraper
scrapped1556533scrapped
scrappers1545843scrappers
scrappier1544413scrappier
scuppers1446533scuppers
sealer63928963sea_ler
seamer84223613sea_mer
seamier93114633seamier
searer65432023sea_rer
seater64534153sea_ter
seepier92912013seepier
shader104218763sha_der
shadier113111153shadier
shaker134319463sha_ker
shakier143411153shakier
shalier103116423shalier
shammer144613143shammer
shape105125113sha_pe_
shaped125020103sha_ped
shapen114414653sha_pen
shapers124016893sha_pers
shapes115124943sha_pes
sharer95025483sha_rer
sharker144313813sharker
sharped134112043sharped
sharpen12389723sharpen
sharpers133810943sharpers
shatter103615693shatter
shaver123718913sha_ver
shipped153312103shipped
shippen14298863shippen
shippers153012303shippers
shnapps1463343shnapp_s
shoppe133110313shoppe_
shopped153512203shopped
shoppers153010753shoppers
shoppes143411383shoppes
simper103616293s_imper
simpler112910863simpler
sipped113720633s_ipped
sippers113117743s_ippers
sippet103519393s_ippet
skanker10268483skanker
skater105015483ska_ter
skipped16358403skipped
skippers16318193skippers
skippet15288453skippet
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slammer113913033slammer
slander84015443slander
slasher104515323slasher
slater64429183sla_ter
slather103816063slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
sleeper93211563sleeper
slipped124711743slipped
slippers123711223slippers
slippery15275853slippery
slippier1256533slippier
sloper84615913s_loper
slopped123511443slopped
sloppier1255703sloppier
smacker153410583smacker
smaller93410333smaller
smarter94113133smarter
smasher123911013smasher
smatter93613333smatter
snacked144013113snacked
snackers143010223snackers
snafued1134933snafued
snagged104010663snagged
snaggier10136303snaggier
snailed83811923snailed
snake94821113sna_ke_
snaked115017593sna_ked
snakes103919603sna_kes
snakey135011273sna_key
snap65727033sna_p__
snapless10287463snapless
snappiest1346483snappiest
snappily1544323snappily
snapping13349653snapping
snappish1545233snappish
snaps74719563sna_p_s
snapweed1443453snapweed
snare54429983sna_re_
snared74824553sna_red
snarers74216663sna_rers
snares65329033sna_res
snarfed11378753snarfed
snarkier12336513snarkier
snarled83612353snarled
snarlers8298753snarlers
snarlier8278183snarlier
snashes105214753snashes
snatcher13167753snatcher
snathe94415113snathe_
snathes104816493snathes
snawed104813733sna_wed
snazzier1642483snazzier
sneaker112910453sneaker
sneakier1245143sneakier
sneaped10338813sneaped
sneer54919953sn__eer
sneerer73512313sneerer
sneezer16237963sneezer
sneller73512843sneller
snicker133012673snicker
snider74413913sn_ider
sniffer13318903sniffer
snifter10349623snifter
snigger9328373snigger
snipe75320573sn_ipe_
sniped94913483sn_iped
snipers93311763sn_ipers
snipes83917393sn_ipes
snippets12225613snippets
snippety15263493snippety
snippy1374843snipp_y
snooker113910303snooker
snooped103711813snooped
snoopers10319833snoopers
snoopier10177273snoopier
snoozer16409183snoozer
snorer64316763sn_orer
snorter74412653snorter
snowier1038783snowier
snubber11277733snubber
snuffer13318843snuffer
snugger9318313snugger
soaker105717533soa_ker
soaped95817973soa_ped
soapers93715923soa_pers
soarer64522243soa_rer
sopped114819903s_opped
soppier112711583soppier
soupier93111753soupier
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spammer133410433spammer
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613073sparger
sparker133914353sparker
sparser94311483sparser
spatter94016523spatter
spawner12347363spawner
speer74623903s__peer
spier75728033s__pier
stabber113610153stabber
stabler94014933stabler
stacker134416263stacker
staffer13299093staffer
stager74821343sta_ger
stagger94212383stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823sta_ler
stalker113912253stalker
stammer116013343stammer
stamped124812813stamped
stampers124211593stampers
stander84316163stander
stapes85028733sta_pes
staple84415823staple_
stapled103613693stapled
staplers103111183staplers
staples93617213staples
starer64027363sta_rer
starker114114693starker
starter73817873starter
starver104611993starver
stater64427553sta_ter
stayer94516483sta_yer
steeper93812773steeper
steppe10319873steppe_
stepped123210053stepped
steppers12289273steppers
steppes113110693steppes
stippler1235543stippler
stomper114111223stomper
stooper93813183stooper
stoper84320093s_toper
stopped124512203stopped
stoppers123910573stoppers
strapped1357813strapped
strappers1346733strappers
strappier1345123strappier
striper94514783striper
stripper1247113stripper
stropper1247753stropper
stumper113610093stumper
suaver93014233sua_ver
sumpter1138873sumpter
super74924483s__uper
supped114415703s_upped
suppers113314693s_uppers
suppler1148433suppler
swabber14297963swabber
swager104013613swa_ger
swagger12389333swagger
swamped15498443swamped
swampers15317473swampers
swampier1544593swampier
swanker14369483swanker
swarmer1247803swarmer
swasher134011503swasher
swather134213593swather
swatter104113323swatter
swayer125210973swa_yer
sweeper12329373sweeper
swooper12389173swooper
swopped15437673swopped
synapse1234133synapse_
synapsed1443133synapsed
synapses1344713synapses
sypher14317083s_ypher
tamper104618513_tamper
taper74829773_ta_per
tapped113820053_tapped
tappers113416543_tappers
tappet103820113_tappet
tipper103918413_tipper
topper103817603_topper
tramper113812153tramper
trapped124512213trapped
trappers123711023trappers
tripper113711923tripper
uncapped1556693uncapped
unhappier1642393unhappier
unmapped1535173unmapped
unriper9188283unriper
unsnapped1443983unsnapped
untapped1376613untapped
upper93714263__upper
vamper134212653_vamper
wapped144416473_wapped
warper114015583_warper
whapped18367573whapped
whappers18276743whappers
whipper173611383whipper
whopper17328503whopper
wrapped15338023wrapped
wrappers15306933wrappers
yapped144415143_yapped
yappers144012253_yappers
yauper11368543_yauper
yawper14437953_yawper
zapped204213523_zapped
zappers203911633_zappers
zappier20458373_zappier
zipper193813123_zipper

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340275176.78319759.3
3Display Results5175170.1862779.6
 (SQL Overall)1786915177.12225090.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.