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

512 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
gappier1236984(None) 
happier143312031happier
nappier114411171nappier
pappier103511591pappier
sappier113613111sappier
zappier20458371zappier
applier1137902_applier
campier133313272campier
capper124421982capp_er
crappier14288132crappier
cuppier1368322cuppier
dapper114016632dapp_er
dippier123111392dippier
flappier1544292flappier
gabbier12379632gabbier
gambier124711972gambier
gamier93617932ga_mier
gammier123711192gammier
gaper86125122ga_p_er
gapped124217122gapp_ed
gappiest13259472gappiest
gapping134214782gapping
gasper94515542gasp_er
gassier83812572gassier
gaudier938452gaudier
gauzier1735632gauzier
gawkier15326522gawkier
gawper12499692gawp_er
gimpier12247942gimpier
gipper114215302gipp_er
gloppier1354672gloppier
goopier103910572goopier
grapier103712602grapier
grappler13336192grappler
gripier103210322gripier
grippier1355202grippier
gulpier1046952gulpier
guppies123310522guppies
gypper14347292gypp_er
hippier143212102hippier
hoppier143110702hoppier
lapper104319952lapp_er
lippier112710572lippier
loppier11369722loppier
mapper124516092mapp_er
napper103718282napp_er
nappie104112262nappie_
nappies114613392nappies
nippier11319832nippier
pappies103214822pappies
peppier10268322peppier
rapier84019992ra_pier
rapper104621572rapp_er
raspier93110642raspier
sapper103822352sapp_er
snappier1266212snappier
soppier112711582soppier
tapper104419612tapp_er
tippier113210542tippier
vampier14308232vampier
waspier12259052waspier
yapper133714512yapp_er
zapper193414022zapp_er
zippier20308192zippier
achier113914263_achier
aerier64823153_aerier
airier64619363_airier
ampler104313303_ampler
aper66336233_a_p_er
appear10379343_appear
appel94615893_app_el
apple94517673_apple_
apples104315763_apples
applet105917433_applet
applied1247483_applied
appliers1235573_appliers
applies11311213_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
barrier94017733barrier
battier93515713battier
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
chappie16298653chappie_
chappies172610093chappies
chippier17297673chippier
choppier17286643choppier
clapper134011863clapp_er
copier103722893_copier
copper124321893copp_er
crampier14288903crampier
crapper133913193crapp_er
crappie13298983crappie_
crappies142911153crappies
crepier1139733crepier
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
gabber114916603ga_bber
gabbler124013303gabbler
gabies93820733ga_bies
gadder93714713ga_dder
gaffer134310133ga_ffer
gager74726293ga__ger
gagger95016513ga_gger
gagster9317633gagster
gainer74117493ga_iner
gainlier965673gainlier
gaiter73819503ga_iter
gallied94115003gallied
gallies84122713gallies
gambiers13337073gambiers
gambir11509773gambi_r
gambler123612683gambler
gamer84928943ga__mer
gammer1112318333ga_mmer
gander84322763ga_nder
ganger83721463ga_nger
ganglier1047603ganglier
gaoler73913573ga_oler
gape75134513ga_p_e_
gaped96123533ga_p_ed
gapers94520473ga_p_ers
gapes86030823ga_p_es
gaping105618923ga_ping
gappy136212033gapp__y
garbler104012563garbler
gargler93710263gargler
garner73917003ga_rner
garpike1435093garpike
garpikes1534373garpikes
garter74420513ga_rter
gasalier936443gasalier
gaselier946963gaselier
gasher104320373ga_sher
gasifier1236273gasifier
gasolier935833gasolier
gasped104814293gasp_ed
gaspers105014133gasp_ers
gasping113714363gasping
gasser75017773ga_sser
gaster75027353ga_ster
gater64533653ga__ter
gather104115853ga_ther
gaucher1337233gaucher
gaudies9311973gaudies
gauffer1474423gauffer
gauger84714853ga_uger
gaunter82910713gaunter
gawker14559353ga_wker
gawkies15429123gawkies
gawped13509073gawp_ed
gawpers13448313gawp_ers
gawping14418463gawping
gawsie1038463gawsie_
gayer94519193ga__yer
gazer155720073ga__zer
geekier12286393geekier
gemmier12337383gemmier
germier10309543germier
giddier10308723giddier
ginnier8298983ginnier
gipped124815903gipp_ed
gippers123212083gipp_ers
gipping133813123gipping
gipsied1135873gipsied
gipsies1039903gipsies
girlier8289523girlier
glacier103911293glacier
gladier93810993gladier
gladlier1034343gladlier
glairier944833glairier
glarier84112203glarier
glassier9289083glassier
glazier17409353glazier
gluier7310263g_luier
glumpier1334873glumpier
gnarlier9255163gnarlier
gnattier934263gnattier
godlier938893godlier
goofier11339313goofier
gooier73516213g_ooier
goonier83612843goonier
goosier83512563goosier
gopher1239183g_opher
gorier73719373g_orier
gorsier83811073gorsier
goutier82612353goutier
grabbier13316653grabbier
grainier9218903grainier
grapple12378003grapple_
grappled14336093grappled
grapplers14274303grapplers
grapples13348123grapples
grasper10389793grasp_er
grassier9349283grassier
grazier173611133grazier
grimier103210433grimier
griper94114613grip_er
gripper124410713gripper
grodier939673grodier
groper94517253grop_er
grumpier1334803grumpier
gulfier1137793gulfier
gulper93410213gulp_er
gummier12349473gummier
gunkier12369553gunkier
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
gypped15377113gypp_ed
gyppers15235503gypp_ers
gypping16305843gypping
gypsied1443263gypsied
gypsies1335953gypsies
gypster1333953gypster
hairier103111053hairier
hammier143510653hammier
hamper134518653hamp_er
handier113817443handier
happed144820103happ_ed
happen134812193happ_en
happiest152411673happiest
happily1745763happily
happing153817233happing
hardier114721543hardier
harper115018403harp_er
harpies123818313harpies
harrier104417753harrier
hastier103916623hastier
haulier1059943haulier
hazier184712403ha_zier
hempier14319003hempier
hepper133412663hepp_er
hipper133818023hipp_er
hippie132811243hippie_
hippies142813743hippies
hopper134218483hopp_er
humpier143110723humpier
jaggier16339183jaggier
jammier18408023jammier
japer146218883ja_p_er
jasper154610383jasp_er
jazzier2233883jazzier
jumpier18317943jumpier
kipper143414213kipp_er
knapper15387153knapp_er
koppie14277883koppie_
koppies153210013koppies
lacier84020093la_cier
lakier104716273la_kier
lambier113611643lambier
lankier113711633lankier
lapped114320033lapp_ed
lappers113717463lapp_ers
lappet103817723lapp_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
marlier92614773marlier
marrier93817523marrier
massier93615223massier
matier84321523ma_tier
mazier175013063ma_zier
mopier103914783_mopier
mopper126215003mopp_er
naggier9309153naggier
nappe96114993napp_e_
napped114218163napp_ed
nappers114214863napp_ers
nappes104515623napp_es
nappiest122510883nappiest
napping123514183napping
nastier74115293nastier
nattier73614623nattier
nipper103715713nipp_er
oakier104011393oa_kier
pacier105018683pa_cier
palier85023563pa_lier
pallier94417163pallier
palmier113312173palmier
pamper124316663pamp_er
panier84425503pa_nier
pannier93613353pannier
paper95128663pa_p_er
paperer113111903paperer
pappi84810893pappi__
pappiest112611113pappiest
parrier93717653parrier
partier93520713partier
pastier94320383pastier
pauper103511943paup_er
pawkier16236613pawkier
pepper93512943pepp_er
pier66035293___pier
piper96523193__piper
pipier104913983_pipier
plier75221283__plier
popper93615963popp_er
poppied11388983poppied
poppies102816193poppies
preppier1156643preppier
prier75027763__prier
pulpier1148623pulpier
puppies103212613puppies
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
ropier84118803_ropier
roupier9319493roupier
saggier92912063saggier
sagier73717163sa_gier
sallier73320423sallier
saltier74318633saltier
sampler113212013sampler
sandier84017843sandier
sapped114422013sapp_ed
sappers113518903sapp_ers
sapphire1543803sapphire
sappiest122612573sappiest
sappily1437163sappily
sapping123519313sapping
sarkier113413313sarkier
sassier73413233sassier
saucier9810283saucier
savvier1335483savvier
scrappier1544423scrappier
seepier92912013seepier
sipper103920993sipp_er
slapper113512463slapp_er
slippier1256533slippier
sloppier1255703sloppier
snapper113512073snapp_er
snippier1255793snippier
soapier93411713soapier
soupier93111753soupier
spacier114011633spacier
spier75728033__spier
sprier84119063_sprier
strappier1345133strappier
supper104115433supp_er
suppler1148433suppler
supplier1246603supplier
swampier1544593swampier
swapper14359703swapp_er
tackier133712523tackier
talkier114011843talkier
tallier72817213tallier
tamper104618513tamp_er
tangier83013903tangier
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
unhappier1642393unhappier
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
zappiest21228023zappiest
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.1561145455.1
2DLD Change Limit1340275125.97022450.1
3Display Results5125120.1862752.7
 (SQL Overall)1786915126.31228309.7
 
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.