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

460 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
nappier11441117(None) 
gappier12369841gappier
happier143312041happier
napper103718281napp_er
nappie104112261nappie_
nappies114613401nappies
nippier11319831nippier
pappier103511601pappier
sappier113613121sappier
snappier1266221snappier
zappier20458371zappier
applier1137902_applier
campier133313272campier
capper124421982capp_er
crappier14288142crappier
cuppier1368322cuppier
dapper114016632dapp_er
dippier123111392dippier
flappier1544302flappier
hippier143212102hippier
hoppier143110702hoppier
knapper15387152knapp_er
lapper104319952lapp_er
lippier112710572lippier
loppier11369722loppier
mapper124516092mapp_er
naggier9309152naggier
nappe96114992napp_e_
napped114218162napp_ed
nappers114214862napp_ers
nappes104515622napp_es
nappiest122510892nappiest
napping123514182napping
nastier74115292nastier
nattier73614622nattier
nipper103715712nipp_er
pappies103214832pappies
peppier10268322peppier
rapier84019992ra_pier
rapper104621572rapp_er
raspier93110642raspier
sapper103822352sapp_er
snapper113512072snapp_er
snippier1255792snippier
soppier112711582soppier
tapper104419612tapp_er
tippier113210542tippier
unhappier1642402unhappier
vampier14308232vampier
waspier12259052waspier
yapper133714512yapp_er
zapper193414022zapp_er
zippier20308192zippier
achier113914263_achier
aerier64823163_aerier
airier64619363_airier
ampler104313303_ampler
angrier839023angrier
antsier7410773antsier
aper66336233_a_p_er
appear10379343_appear
appel94615893_app_el
apple94517673_apple_
apples104315763_apples
applet105917433_applet
applied1247483_applied
appliers1235573_appliers
applies11311223_applies
apposer1147483_apposer
appriser1246783_appriser
apprizer2145463_apprizer
apter76120203_a_pter
artier63419733_artier
ashier94714833_ashier
asper75520433_asp_er
aspire8612123_aspire
aspirer967903_aspirer
babier103515573ba_bier
baggier113611643baggier
bagpiper1542393bagpiper
balkier134111983balkier
balmier113811513balmier
baptizer2134893baptizer
barkier133814483barkier
barmier114313043barmier
barnier93213673barnier
barrier94017753barrier
battier93515723battier
bawdier13378203bawdier
bopper123813833bopp_er
bumpier13359203bumpier
buppie12288733buppie_
buppies133011063buppies
cagier93715933ca_gier
cahier113615773ca_hier
cakier123115243ca_kier
caliper11410963caliper
camper124722213camp_er
cannier94014163cannier
caper94831623ca_p_er
caperer113013403caperer
caponier1237883caponier
capped134721853capp_ed
cappers134419403capp_ers
capping143819673capping
carper104923633carp_er
carrier93619583carrier
cashier123713323cashier
cattier93317073cattier
chappie16298663chappie_
chappies172610103chappies
chippier17297673chippier
choppier17286653choppier
clapper134011863clapp_er
copier103722903_copier
copper124321893copp_er
crampier14288903crampier
crapper133913193crapp_er
crappie13298993crappie_
crappies142911173crappies
crepier1139753crepier
cupper124313863cupp_er
daffier1457833daffier
dallier84215373dallier
damper114117753damp_er
dandier93714573dandier
dapped124516763dapp_ed
dapperer1335763dapperer
dapping133714793dapping
dapple1138853dapple_
dappled1336393dappled
dapples1238993dapples
dashier114311183dashier
daubier1037103daubier
dipper114017793dipp_er
dopier93515923_dopier
drippier1385043drippier
dumpier12409653dumpier
earlier72612743earlier
easier64218463ea_sier
emptier1187603emptier
faddier1237783faddier
faggier12309843faggier
fancier123412063fancier
farrier103514893farrier
fattier103513463fattier
fawnier13296363fawnier
flapper14359203flapp_er
floppier1554633floppier
gabbier12379633gabbier
gambier124711973gambier
gamier93617933ga_mier
gammier123711193gammier
gaper86125123ga_p_er
gapped124217123gapp_ed
gappiest13259483gappiest
gapping134214783gapping
gasper94515543gasp_er
gassier83812573gassier
gaudier938453gaudier
gauzier1735633gauzier
gawkier15326523gawkier
gawper12499693gawp_er
gimpier12247943gimpier
gipper114215303gipp_er
gloppier1354673gloppier
gnarlier9255163gnarlier
gnattier934263gnattier
goopier103910573goopier
grapier103712603grapier
grappler13336193grappler
gripier103210323gripier
grippier1355203grippier
gulpier1046953gulpier
guppies123310523guppies
gypper14347293gypp_er
hairier103111053hairier
hammier143510653hammier
hamper134518653hamp_er
handier113817443handier
happed144820103happ_ed
happen134812193happ_en
happiest152411683happiest
happily1745763happily
happing153817233happing
hardier114721543hardier
harper115018403harp_er
harpies123818323harpies
harrier104417763harrier
hastier103916623hastier
haulier1059943haulier
hazier184712403ha_zier
hempier14319003hempier
hepper133412663hepp_er
hipper133818023hipp_er
hippie132811243hippie_
hippies142813753hippies
hopper134218483hopp_er
humpier143110723humpier
jaggier16339183jaggier
jammier18408023jammier
japer146218883ja_p_er
jasper154610383jasp_er
jazzier2233883jazzier
jumpier18317943jumpier
kipper143414213kipp_er
knapped16397103knapp_ed
knappers16315643knapp_ers
knapping17314973knapping
koppie14277883koppie_
koppies153210013koppies
lacier84020093la_cier
lakier104716273la_kier
lambier113611643lambier
lankier113711633lankier
lapped114320033lapp_ed
lappers113717463lapp_ers
lappet103817733lapp_et
lapping124117023lapping
lapser84113143la_pser
lardier83518343lardier
larkier113711523larkier
lathier10310833lathier
lazier154214613la_zier
lipper104219633lipp_er
loopier93711193loopier
lopper103717203lopp_er
lumpier113410143lumpier
magpie1139093magpie_
magpies12310363magpies
malmier113611953malmier
maltier93015483maltier
mangier104114063mangier
manlier92414023manlier
mapped134015883mapp_ed
mappers133313783mapp_ers
mapping143413993mapping
marlier92614783marlier
marrier93817523marrier
massier93615223massier
matier84321523ma_tier
mazier175013063ma_zier
mopier103914783_mopier
mopper126215003mopp_er
nabber104913543na_bber
nadir61012973na_di_r
nagger84016123na_gger
nailer64119363na_iler
naiver94311353na_iver
nakeder1254363nakeder
namer75622103na__mer
nancies93516843nancies
nannie63713223nannie_
nannies73015203nannies
nape65230803na_p_e_
naperies10313903naperies
napery11489813na_p_ery
napes74828463na_p_es
napkin1236903napki_n
napkins1336673napkins
nappa98511863napp__a
nappas105511613napp_as
nappiness1335233nappiness
nappy126312333napp__y
nasties73520493nasties
natter64420743na_tter
navies95218623na_vies
navvies1335323navvies
nearlier836803nearlier
needier84010623needier
nerdier83110363nerdier
nervier10298843nervier
nettier74211813nettier
newsier10147233newsier
niftier10328713niftier
nipped113615853nipp_ed
nippers113012623nipp_ers
nippiest12279983nippiest
nippily1444713nippily
nipping123412873nipping
nipple103410373nipple_
nippled12307643nippled
nipples11319663nipples
nittier73512243nittier
nobbier11309163nobbier
noisier759463noisier
nosier63716333n_osier
nubbier11308133nubbier
nutsier7329253nutsier
nuttier73112023nuttier
oakier104011393oa_kier
pacier105018683pa_cier
palier85023563pa_lier
pallier94417163pallier
palmier113312173palmier
pamper124316663pamp_er
panier84425503pa_nier
pannier93613353pannier
paper95128663pa_p_er
paperer113111903paperer
pappi84810893pappi__
pappiest112611123pappiest
parrier93717653parrier
partier93520713partier
pastier94320383pastier
pauper103511943paup_er
pawkier16236613pawkier
pepper93512943pepp_er
pier66035293___pier
piper96523193__piper
pipier104913983_pipier
plier75221283__plier
popper93615963popp_er
poppied11388993poppied
poppies102816203poppies
preppier1156643preppier
prier75027763__prier
pulpier1148623pulpier
puppies103212623puppies
quippier2133773quippier
racier85120973ra_cier
rainier71614263rainier
rallier73816273rallier
rammier112811023rammier
randier83618473randier
rangier83714353rangier
raper74932753ra_p_er
rapider1067903rapider
rapiers95012873ra_piers
rapped114122683rapp_ed
rappee103618673rapp_ee
rappees113611453rappees
rappel104211953rapp_el
rappen103512713rapp_en
rappers113618443rapp_ers
rapping123619103rapping
rappini11347573rappini
rasper83917333rasp_er
rattier74015593rattier
replier94214973replier
ripper103518653ripp_er
rippler113210103rippler
ripplier1234463ripplier
ropier84118813_ropier
roupier9319493roupier
saggier92912063saggier
sagier73717163sa_gier
sallier73320423sallier
saltier74318633saltier
sampler113212013sampler
sandier84017843sandier
sapped114422013sapp_ed
sappers113518903sapp_ers
sapphire1543803sapphire
sappiest122612583sappiest
sappily1437163sappily
sapping123519313sapping
sarkier113413313sarkier
sassier73413233sassier
saucier9810283saucier
savvier1335483savvier
scrappier1544443scrappier
seepier92912013seepier
sipper103920993sipp_er
slapper113512473slapp_er
slippier1256543slippier
sloppier1255713sloppier
snaggier10136303snaggier
snakier112810003sna_kier
snapped124611203snapp_ed
snappers123510173snapp_ers
snappiest1346503snappiest
snappily1544323snappily
snapping13349653snapping
snappish1545243snappish
snarkier12336513snarkier
snarlier8278183snarlier
snazzier1642483snazzier
snipper113911333snipp_er
snoopier10177273snoopier
soapier93411713soapier
soupier93111753soupier
spacier114011633spacier
spier75728033__spier
sprier84119063_sprier
strappier1345143strappier
supper104115433supp_er
suppler1148433suppler
supplier1246603supplier
swampier1544593swampier
swapper14359703swapp_er
tackier133712523tackier
talkier114011843talkier
tallier72817213tallier
tamper104618513tamp_er
tangier83013913tangier
taper74829773ta_p_er
taperer92511793taperer
tapir75917063ta_pi_r
tapped113820053tapp_ed
tappers113416543tapp_ers
tappet103820113tapp_et
tapping123317133tapping
tapster9299273tapster
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tawnier10318463tawnier
tawpie11339143tawpie_
tawpies12309873tawpies
tipper103918413tipp_er
tippler11348343tippler
tipsier9268893tipsier
topper103817603topp_er
trampier12318243trampier
trapper113912803trapp_er
trippier1246623trippier
typier1137333_typier
unapplied1443743unapplied
upper93714263_upp_er
vamper134212653vamp_er
vampire14296673vampire
vaporer1236983vaporer
varier94619353va_rier
vastier103613203vastier
wackier16369733wackier
wanier93920683wa_nier
wapped144416473wapp_ed
wapping153514603wapping
warier93722893wa_rier
warper114015583warp_er
wartier103413913wartier
washier133611153washier
wavier124613083wa_vier
waxier16439903wa_xier
weepier12319273weepier
whapper17348273whapp_er
whippier18265823whippier
wimpier14248053wimpier
wispier12249403wispier
wrapper14368333wrapp_er
yapped144415143yapp_ed
yappers144012253yapp_ers
yapping153412613yapping
yauper11368543yaup_er
yawper14437953yawp_er
yippie13277843yippie_
yippies14279293yippies
yuppie13297133yuppie_
yuppies14339263yuppies
zanier154314713za_nier
zapped204213523zapp_ed
zappers203911633zapp_ers
zappiest21228033zappiest
zapping213211473zapping
zaptieh2144563zaptieh
zipper193813123zipp_er

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.403443402.0
2DLD Change Limit1340274605.94022563.5
3Display Results4604600.1702705.9
 (SQL Overall)1786914606.51327436.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.