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

428 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
vampier1430823(None) 
campier133313271campier
vamper134212651vamp_er
vampire14296671vampire
ampler104313302_ampler
bumpier13359202bumpier
camper124722212camp_er
crampier14288902crampier
damper114117752damp_er
dumpier12409652dumpier
gambier124711972gambier
gamier93617932gam_ier
gammier123711192gammier
gappier12369842gappier
gimpier12247942gimpier
hammier143510652hammier
hamper134518652hamp_er
happier143312032happier
hempier14319002hempier
humpier143110722humpier
jammier18408022jammier
jumpier18317942jumpier
lambier113611642lambier
lumpier113410142lumpier
nappier114411172nappier
pamper124316662pamp_er
pappier103511592pappier
rammier112811022rammier
rapier84019992ra_pier
raspier93110642raspier
sampler113212012sampler
sappier113613112sappier
swampier1544592swampier
tamper104618512tamp_er
trampier12318242trampier
vamped144211012vamp_ed
vampers143111622vamp_ers
vampiest15237642vampiest
vamping152810232vamping
vampires15226032vampires
vampish1766282vampish
varier94619352va_rier
vastier103613202vastier
waspier12259052waspier
wimpier14248052wimpier
zappier20458372zappier
achier113914263_achier
aerier64823153_aerier
airier64619363_airier
ambeer104511603_ambeer
amber94523213_am_ber
ambler104916453_ambler
ameer75618983_am_eer
amie66339853_am_ie_
amies76837693_am_ies
amir65129753_am_i_r
amped104820513_amp_ed
ampere10514413_amp_ere
amping114317573_amping
ample94720303_ample_
amuser84712623_amuser
aper66336233_a_p_er
applier1137903_applier
apter76120203_a_pter
artier63419733_artier
ashier94714833_ashier
asper75520433_asp_er
aspire8612123_aspire
aspirer967903_aspirer
babier103515573ba_bier
baggier113611643baggier
bagpiper1542393bagpiper
balkier134111983balkier
balmier113811513balmier
barkier133814483barkier
barmier114313043barmier
barnier93213673barnier
barrier94017733barrier
battier93515713battier
bawdier13378203bawdier
beamier113411943beam_ier
bumper123714343bump_er
cagier93715933ca_gier
cahier113615773ca_hier
cakier123115243ca_kier
caliper11410963caliper
camber124418483cam_ber
cammie124615293cammie_
cammies134016483cammies
camped134720233camp_ed
campers134220293camp_ers
campfire1744023campfire
camphire1745893camphire
camphor1636133camphor
campi116217783campi__
campiest142212133campiest
campily1638273campily
camping143118973camping
campion133011413campion
cannier94014163cannier
caper94831623ca_p_er
capper124421983ca_pper
carper104923633carp_er
carrier93619583carrier
cashier123713323cashier
cattier93317073cattier
champer163813413champ_er
clammier1435843clammier
clamper134012993clamp_er
clumpier1435583clumpier
comfier1439163comfier
compeer133811553compeer
compiler1438373compiler
complier14310253complier
copier103722893_copier
crappier14288133crappier
crepier1139743crepier
crimpier14287323crimpier
cuppier1368323cuppier
daffier1457833daffier
dallier84215373dallier
damager1157973damager
dammer114317933dam_mer
damner95213433dam_ner
damped124315583damp_ed
dampen114310593damp_en
dampener1335533dampener
dampers123915693damp_ers
damping133414003damping
dampish1567663dampish
dandier93714573dandier
dapper114016633da_pper
dashier114311183dashier
daubier1037103daubier
dimplier1336673dimplier
dippier123111393dippier
dopier93515923_dopier
dumper114615213dump_er
earlier72612743earlier
easier64218463ea_sier
elmier839813elm_ier
empire1039323_empire
emptier1187603_emptier
faddier1237783faddier
faggier12309843faggier
fancier123412063fancier
farrier103514893farrier
fattier103513463fattier
fawnier13296363fawnier
flamier123112143flam_ier
flappier1544293flappier
foamier12339003foam_ier
frumpier1534173frumpier
fumier11310903fum_ier
gabbier12379633gabbier
gambiers13337073gambiers
gambir11509773gambi_r
gambler123612683gambler
gamer84928943gam__er
gammer1112318333gam_mer
gaper86125123ga_p_er
gasper94515543gasp_er
gassier83812573gassier
gaudier938453gaudier
gauzier1735633gauzier
gawkier15326523gawkier
gawper12499693gawp_er
gemmier12337383gemmier
glumpier1334873glumpier
goopier103910573goopier
grapier103712603grapier
gripier103210323gripier
grumpier1334803grumpier
gulpier1046953gulpier
gummier12349473gummier
hairier103111053hairier
hammer138120033ham_mer
hamperer15379093hamperer
hampers143616953hamp_ers
hamster12810423hamster
handier113817443handier
hardier114721543hardier
harper115018403harp_er
harpies123818313harpies
harrier104417753harrier
hastier103916623hastier
haulier1059943haulier
hazier184712403ha_zier
hempie132410563hempie_
hippier143212103hippier
homier116416993hom_ier
hoppier143110703hoppier
humper134115883hump_er
jaggier16339183jaggier
jammer174014133jam_mer
jammies183611293jammies
japer146218883ja_p_er
jasper154610383jasp_er
jazzier2233883jazzier
jimper17389863jimp_er
jumper173612373jump_er
lacier84020093la_cier
lakier104716273la_kier
lamber104418493lam_ber
lambie103213673lambie_
lambies113015113lambies
lamer75233703lam__er
lamped114017543lamp_ed
lampers113817333lamp_ers
lamping123116003lamping
lampion11278303lampion
lamprey1434863lamprey
lamster9109913lamster
lankier113711633lankier
lapper104319953la_pper
lapser84113143la_pser
lardier83518343lardier
larkier113711523larkier
lathier10310833lathier
lazier154214613la_zier
limbier11349113limbier
limier83518723lim_ier
limper104117853limp_er
limpsier1234433limpsier
lippier112710573lippier
loamier9349163loam_ier
loopier93711193loopier
loppier11369723loppier
lumper103816653lump_er
magpie1139093magpie_
magpies12310363magpies
malmier113611953malmier
maltier93015483maltier
mamie95826003mam_ie_
mamies104626243mam_ies
mammer94218863mam_mer
mammie94313783mammie_
mammies104314763mammies
mamzer19459833mam_zer
mangier104114063mangier
manlier92414023manlier
mapper124516093ma_pper
marlier92614773marlier
marrier93817523marrier
massier93615223massier
matier84321523ma_tier
mazier175013063ma_zier
mopier103914783_mopier
mumper123513523mump_er
naggier9309153naggier
namer75622103nam__er
napper103718283na_pper
nappie104112263nappie_
nappies114613393nappies
nastier74115293nastier
nattier73614623nattier
nippier11319833nippier
oakier104011393oa_kier
pacier105018683pa_cier
palier85023563pa_lier
pallier94417163pallier
palmier113312173palmier
pamperer14228333pamperer
pampero13328093pamp_ero
pampers133615933pamp_ers
panier84425503pa_nier
pannier93613353pannier
paper95128663pa_p_er
pappies103214823pappies
parrier93717653parrier
partier93520713partier
pastier94320383pastier
pauper103511943paup_er
pawkier16236613pawkier
peppier10268323peppier
pier66035293___pier
pimplier1445413pimplier
pipier104913983_pipier
pulpier1148623pulpier
pumper124415553pump_er
racier85120973ra_cier
rainier71614263rainier
rallier73816273rallier
rambler113313263rambler
ramie75027823ram_ie_
ramies84630463ram_ies
rammer103519653ram_mer
rampager1344453rampager
ramped114617903ramp_ed
rampike1536603rampike
rampikes1635393rampikes
ramping123316873ramping
rampion11298583rampion
randier83618473randier
rangier83714353rangier
raper74932753ra_p_er
rapider1067903ra_pider
rapiers95012873ra_piers
rapper104621573ra_pper
rasper83917333rasp_er
rattier74015593rattier
revamper1533533revamp_er
rimier83916273rim_ier
romper104213683romp_er
ropier84118803_ropier
roupier9319493roupier
rummier11309563rummier
rumplier1235303rumplier
saggier92912063saggier
sagier73717163sa_gier
sallier73320423sallier
saltier74318633saltier
samiel8313333sam_iel
samphire1545833samphire
sample104215013sample_
sampled123410793sampled
samplers12299403samplers
samples112815453samples
sandier84017843sandier
sapper103822353sa_pper
sarkier113413313sarkier
sassier73413233sassier
saucier9810283saucier
savvier1335483savvier
scamper134613163scamp_er
scampies1439323scampies
seamier93114633seam_ier
seepier92912013seepier
simper103616293simp_er
simpler112910863simpler
skimpier1634293skimpier
snappier1266213snappier
soapier93411713soapier
soppier112711583soppier
soupier93111753soupier
spier75728033__spier
stamper113714403stamp_er
stumpier1255883stumpier
sumpter1138873sumpter
swamper14349313swamp_er
tackier133712523tackier
talkier114011843talkier
tallier72817213tallier
tamer75230103tam__er
tammie104212693tammie_
tammies113814683tammies
tamped114317043tamp_ed
tamperer12248893tamperer
tampers113516743tamp_ers
tamping122815813tamping
tampion11298663tampion
tangier83013903tangier
taper74829773ta_p_er
tapir75917063ta_pi_r
tapper104419613ta_pper
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tawnier10318463tawnier
tawpie11339143tawpie_
tawpies12309873tawpies
temper103914093temp_er
tempter11358213tempter
tippier113210543tippier
tramper113812163tramp_er
trampler12278013trampler
typier1137333_typier
umpire1047893_umpire
vaguer10448443va_guer
vainer93714573va_iner
vair75624143va__i_r
valuer93911443va_luer
vamose1159283vamose_
vamosed1335923vamosed
vamoses1239143vamoses
vamp115521543vamp___
vampiric1742613vampiric
vamps125415483vamp__s
vampy15539403vamp__y
vanner94215843va_nner
vapid115614283va_pi_d
vapor104013093va_p_or
vaporer1236983vaporer
vapour11378873va_pour
varied104817863va_ried
variers103712663va_riers
varies94330873va_ries
vaster94521023va_ster
vaulter10257713vaulter
vaultier1144293vaultier
vaunter10309603vaunter
vealier102712173vealier
veinier10269583veinier
verier94620963v_erier
vernier102711273vernier
vesper1138083vesp_er
vier75428153v___ier
viewier1334983viewier
vinier93716743v_inier
viper105017303v_ip_er
vizier184311023v_izier
vomer105517383vom__er
vomiter1237953vomiter
vuggier12296813vuggier
wackier16369733wackier
wamblier15275733wamblier
wampish1777293wampish
wanier93920683wa_nier
warier93722893wa_rier
warper114015583warp_er
wartier103413913wartier
washier133611153washier
wavier124613083wa_vier
waxier16439903wa_xier
weepier12319273weepier
wispier12249403wispier
wombier1436543wombier
yammer133713183yam_mer
yapper133714513ya_pper
yauper11368543yaup_er
yawper14437953yawp_er
yummier14306843yummier
zanier154314713za_nier
zapper193414023za_pper
zippier20308193zippier

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.406440125.6
2DLD Change Limit1340274286.42320866.7
3Display Results4284280.1562743.6
 (SQL Overall)1786914286.98525582.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.