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

364 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
nappie10411226(None) 
nappe96114991napp_e
nappier114411171nappier
nappies114613401nappies
apple94517672_apple
buppie12288732buppie
chappie16298662chappie
crappie13298982crappie
dapple1138852dapple
gappier12369842gappier
happier143312042happier
hippie132811242hippie
koppie14277882koppie
magpie1139092magpie
nannie63713222nannie
nape65230802na_p_e
napkin1236902napkin
nappa98511862napp_a
nappas105511612nappas
napped114218162napped
napper103718282napper
nappes104515622nappes
nappiest122510892nappiest
napping123514182napping
nappy126312332napp_y
nippier11319832nippier
nipple103410372nipple
pappi84810892pappi_
pappier103511602pappier
pappies103214832pappies
rappee103618672rappee
sappier113613122sappier
snappier1266222snappier
tawpie11339142tawpie
yippie13277842yippie
yuppie13297132yuppie
zappier20458372zappier
aerie54634603_aerie
aggie73415013_aggie
alkie95520033_alkie
alpine84417373_alpine
amie66339853_a_mie
ample94720303_ample
anomie83215963anomie
anopia83412393anopia
apace94718383_apace
ape57251183_a_p_e
aphid115515393_aphid
aphis105917133_aphis
aplite8316393_aplite
app76827603_app__
appal95315223_appal
appel94615893_appel
apples104315763_apples
applet105917433_applet
applied1247483_applied
applier1137903_applier
applies11311223_applies
apply125111393_apply
appose10411993_appose
apprise11310193_apprise
apprize2038183_apprize
apps86319693_app_s
apse67725383_a_pse
apsis75718293_apsis
aspic95114733_aspic
aspire8612123_aspire
aspis74618143_aspis
baddie104114033baddie
baggie102912193baggie
bagpipe1453113bagpipe
bailie83818363bailie
baptise1139553baptise
baptize2036983baptize
barbie105018353barbie
barmie103816393barmie
bawtie113812143bawtie
buppies133011063buppies
cabbie122913353cabbie
caddie104316453caddie
cammie124615293cammie
campi116217783campi_
campier133313273campier
cannie83819363cannie
cape87242783ca_p_e
capiz18514563ca_piz
caplin103216303caplin
capote10315733capote
capped134721853capped
capper124421983capper
capping143819673capping
capric12411803capric
caprice1349683caprice
caprine11314233caprine
capris10415083capris
capsid11312413capsid
capsize2037623capsize
captive1438973captive
carnie84421093carnie
carpi94319393carpi_
cattie85221023cattie
cavie104621593ca_vie
chappies172610103chappies
chippie16297693chippie
coppice1537483coppice
cowpie133511513cowpie
crappier14288133crappier
crappies142911163crappies
croppie13278793croppie
cuppier1368323cuppier
daphne12237013daphne
dapped124516763dapped
dapper114016633dapper
dapping133714793dapping
dappled1336393dappled
dapples1238993dapples
darkie113714013darkie
dassie74615573dassie
dautie72914703dautie
dawtie103011093dawtie
dippier123111393dippier
faerie93514683faerie
falsie93513853falsie
farcie114816473farcie
fipple13329063fipple
flappier1544303flappier
frappe13286953frapp_e
gape75134513ga_p_e
gapped124217123gapped
gappiest13259483gappiest
gapping134214783gapping
gappy136212033gapp_y
garpike1435093garpike
gawsie1038463gawsie
grapple12378003grapple
guppies123310523guppies
hackie154615623hackie
hankie133915713hankie
haplite12310703haplite
happed144820103happed
happen134812193happen
happiest152411683happiest
happily1745763happily
happing153817233happing
happy155813533happ_y
haptic13511893haptic
harpies123818323harpies
harpin113614383harpin
hatpin112610613hatpin
hawkie163810093hawkie
hempie132410563hempie
hippier143212103hippier
hippies142813753hippies
hoppier143110703hoppier
hopple132910483hopple
jape134923423ja_p_e
kappa13469743kapp_a
kappas144410363kappas
kelpie12308613kelpie
kewpie15465413kewpie
knapped16397103knapped
knapper15387153knapper
knapping17314973knapping
koppies153210013koppies
laddie83713173laddie
lambie103213673lambie
lapin75222923la_pin
lapis76223153la_pis
lapped114320033lapped
lapper104319953lapper
lappet103817733lappet
lapping124117023lapping
lapse74917683la_pse
lassie64917743lassie
lippier112710573lippier
loppier11369723loppier
magpies12310363magpies
mamie95826003ma_mie
mammie94313783mammie
maple95521143ma_ple
maplike15299273maplike
mapped134015883mapped
mapper124516093mapper
mapping143413993mapping
mashie11315933mashie
mavie104722563ma_vie
nabe66029493na__be
nabis76020583na_bis
nacre75715363na_cre
nadir61012973na_dir
nae35952743na___e
naevi867873naevi_
naggier9309153naggier
naif76839023na__if
nail45838653na__il
naive85116213na_ive
name65637413na__me
nance74721843na_nce
nancies93516843nancies
nandin7313033nandin
nankin1039673nankin
nannies73015203nannies
naoi46024633na_oi_
nap56753203na_p__
napa66927263na_p_a
napalm1047263napalm
napas75924353na_pas
naperies10313903naperies
napery11489813napery
napes74828463na_pes
napkins1336673napkins
nappers114214863nappers
nappiness1335233nappiness
naps66238583na_p_s
nardine82712573nardine
nargile847653nargile
naric76824173na_ric
narine63422553narine
naris55735293na_ris
nastic82915973nastic
nastier74115293nastier
nasties73520493nasties
native9613013native
nattier73614623nattier
nature6311263nature
nauplii942163nauplii
navaid1037653navaid
nave75732313na__ve
navies95218623na_vies
navvies1335323navvies
nazi136219873na_zi_
nazis145216083na_zis
nellie63614813nellie
newbie11135413newbie
newie81813483n_ewie
newsie9138213newsie
nipped113615853nipped
nipper103715713nipper
nippiest12279983nippiest
nippily1444713nippily
nipping123412873nipping
nippled12307643nippled
nipples11319663nipples
nippy124911113nipp_y
nixie125114943n_ixie
noogie73612313noogie
nookie103712433nookie
nope65934193n_op_e
nudie65118673n_udie
palpi95414553palpi_
panpipe1034833panpipe
pantie84326473pantie
papain10313793papain
pappiest112611123pappiest
pappose1047413pappose
pappus9408373pappus
pappy114713803papp_y
papule102212133papule
pardie96021443pardie
pastie85525523pastie
pattie84020963pattie
peppier10268323peppier
pie55457403___pie
pipe86434433__pipe
pippin92810303pippin
plie65127393__plie
poppied11388983poppied
poppies102816203poppies
popple92710983popple
popsie103013053popsie
potpie103412433potpie
preppie1058093preppie
puppies103212623puppies
ramie75027823ra_mie
rampike1536603rampike
ranpike1335933ranpike
rape65041633ra_p_e
raphae114311733raphae
raphe104916423ra_phe
raphia113511263raphia
raphide13138073raphide
raphis114014323raphis
rapid86422033ra_pid
rapier84019993ra_pier
rapine85023083rapine
rapped114122683rapped
rappees113611453rappees
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
rapping123619103rapping
rappini11347573rappini
raspier93110643raspier
ripple103413913ripple
salpae84614273salpae
salpid9510883salpid
saltie63422433saltie
sample104215013sample
sapid84720933sa_pid
sapote8314363sapote
sapped114422013sapped
sapper103822353sapper
sapphic1644553sapphic
sapphire1543803sapphire
sappiest122612583sappiest
sappily1437163sappily
sapping123519313sapping
sappy125413473sapp_y
sharpie1238403sharpie
snapped124611203snapped
snapper113512073snapper
snappiest1346503snappiest
snappily1544323snappily
snapping13349653snapping
snappish1545243snappish
snappy1366103snapp_y
snippier1255793snippier
soppier112711583soppier
spavie113611383spavie
supple10410203supple
talkie103914443talkie
tammie104212693tammie
tape64538143ta_p_e
tapir75917063ta_pir
tapis75028863ta_pis
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
tapping123317133tapping
tassie66017023tassie
tattie64817513tattie
taupe7314163taup_e
tawie84819813ta_wie
tawpies12309873tawpies
tippier113210543tippier
tipple103411913tipple
topple104411323topple
unapplied1443743unapplied
unhappier1642403unhappier
uppile10178503_uppile
vampier14308233vampier
vampire14296673vampire
vapid115614283va_pid
waddie114013323waddie
waffie15338563waffie
wallie93216803wallie
wapped144416473wapped
wapping153514603wapping
waspier12259053waspier
weepie11258793weepie
yabbie13308663yabbie
yapped144415143yapped
yapper133714513yapper
yapping153412613yapping
yippee132810743yippee
yippies14279293yippies
yuppies14339263yuppies
zapped204213523zapped
zapper193414023zapper
zappiest21228033zappiest
zapping213211473zapping
zappy21548943zapp_y
zaptieh2144563zaptieh
zippier20308193zippier

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 Filter1786911127160.390458182.1
2DLD Change Limit1127163645.81319390.3
3Display Results3643640.1232959.3
 (SQL Overall)1786913646.32628247.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.