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

185 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
vampire1429667(None) 
vampier14308231vampier
vampires15226031vampires
ampere10514412_ampere
aspire8612122_aspire
campfire1744022campfire
camphire1745892camphire
campier133313272campier
empire1039322_empire
rampike1536602rampike
samphire1545832samphire
umpire1047892_umpire
vamper134212652vamper_
vampers143111622vampers
vamping152810232vamping
vampiric1742622vampiric
vampish1766292vampish
abampere1442853abampere
admire949933_admire
afire86215913_a_fire
alpine84417373_alpine
amice96122873_am_ice
amide86128493_am_ide
amie66339853_am_i_e
amine75835383_am_ine
amir65129753_am_ir_
amirs75924923_am_irs
ammine10314493_ammine
amperes11313983_amperes
amping114317573_amping
ample94720303_amp_le
ampler104313303_ampler
ampule10710613_ampule
armoire938133armoire
aspired1068173_aspired
aspirer967903_aspirer
aspires9612043_aspires
attire62412383_attire
avodire1143763avodire
bagpipe1453113bagpipe
bemire103312803bem_ire
bumpier13359203bumpier
camise103319633cam_ise
cammie124615293cammi_e
camper124722213camper_
campers134220293campers
campfires1844123campfires
camphine1738373camphine
camphires1845783camphires
campi116217783campi__
campily1638273campily
camping143118973camping
campion133011413campion
camporee1449343camporee
campsite1447413campsite
compare135814993compare
compere134616623compere
compile13312443compile
crampier14288903crampier
damper114117753damper_
dampers123915693dampers
damping133414003damping
dampish1567663dampish
dumpier12409653dumpier
empires1139853_empires
expire1538023_expire
famine114318193fam_ine
gambier124711973gambier
gambir11509773gambir_
gambirs12359083gambirs
gamier93617933gam_ier
gamine94620153gam_ine
gammier123711193gammier
gappier12369843gappier
garpike1435093garpike
gimpier12247943gimpier
hammier143510653hammier
hamper134518653hamper_
hampered16239933hampered
hamperer15379093hamperer
hampers143616953hampers
happier143312043happier
haywire1644743haywire
hempie132410563hempi_e
hempier14319003hempier
humpier143110723humpier
impure1038383_impure
inspire938253inspire
jamlike20126923jamlike
jammier18408023jammier
jumpier18317943jumpier
lambie103213673lambi_e
lambier113611643lambier
lamiae84817453lam_iae
lampers113817333lampers
lamping123116003lamping
lampion11278303lampion
lamprey1434863lamp_rey
lempira1144193lempira
lumpier113410143lumpier
magpie1139093magpi_e
mamie95826003mam_i_e
mammie94313783mammi_e
mire66748243__m_ire
moire71017323__moire
nappie104112263nappi_e
nappier114411173nappier
pamper124316663pamper_
pampered15229233pampered
pamperer14228333pamperer
pampero13328093pampero
pampers133615933pampers
panpipe1034833panpipe
pappier103511603pappier
ramie75027823ram_i_e
rammier112811023rammier
rampage1237453rampage
rampart11311993rampart
rampikes1635393rampikes
ramping123316873ramping
rampion11298583rampion
rampole1139693rampole
ranpike1335933ranpike
rapier84019993ra_pier
rapine85023083ra_pine
raspier93110643raspier
respire9411543respire
rimfire1243793rimfire
saltire73113043saltire
samite83020603sam_ite
samphires1645513samphires
sample104215013samp_le
sampler113212013sampler
sapphire1543803sapphire
sappier113613123sappier
satire63218003sa_tire
sempre102710093semp_re
spire75828693__spire
suspire937803suspire
swampier1544593swampier
tammie104212693tammi_e
tamper104618513tamper_
tampered13279463tampered
tamperer12248893tamperer
tampers113516743tampers
tamping122815813tamping
tampion11298663tampion
tapir75917063ta_pir_
tapirs84113173ta_pirs
tawpie11339143tawpi_e
trampier12318243trampier
umpired1235783_umpired
umpires1137813_umpires
vaccine1437323vaccine
vagile10310543va_gile
vahine123612113va_hine
vair75624143va__ir_
vairs85019133va__irs
valine94623093va_line
valise92917653va_lise
vamoose1235863vamoose
vamose1159283vam_ose
vamp115521543vamp___
vamped144211013vamp_ed
vampiest15237653vampiest
vampirish1952473vampirish
vampirism1842803vampirism
vamps125415483vamp__s
vampy15539403vamp__y
vapid115614283va_pi_d
vapor104013093va_por_
vapored1336923va_pored
vaporer1236983va_porer
vapors113812693va_pors
vapory14398763va_pory
varier94619353va_rier
vastier103613203vastier
venire93513693v_enire
vespine1237903vespine
vulpine1235903vulpine
wampish1777293wampish
waspier12259053waspier
wimpier14248053wimpier
zaire14311993za__ire
zappier20458373zappier

Search took 10 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.470380193.6
2DLD Change Limit1340271858.20316338.8
3Display Results1851850.406455.7
 (SQL Overall)1786911859.07919681.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.