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

270 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
vespine123790(None) 
despise1038682despise
despite10410122despite
destine83719952destine
pepsine11310602pepsine
repine85627812re_pine
reshine102816942reshine
respire9411542respire
respite9513032respite
resupine1037542resupine
sestine73017922sestine
spine76534422__spine
venine93718432ve_nine
versine102515172versine
vespid1246082vespi_d
vespids1334612vespids
vestige1137432vestige
vesting114618682vesting
vulpine1235902vulpine
aedine73218393ae_dine
alpine84417373_alpine
arsine64021043ars_ine
aspire8612123_aspire
auspice1136523auspice
beeline93314723beeline
beeping124013913beeping
beguine1068503beguine
benzine1839343benzine
berline93716853berline
beside95114613bes_ide
beslime1146833beslime
besmile1137463besmile
bespake15436963bespake
bespoke15468113bespoke
besting104923923besting
betaine9413783betaine
cassine93817283cassine
cervine122610803cervine
cessing103814813cessing
chopine143512263chopine
cosine83823513cos_ine
cystine1239333cystine
decline103716613decline
define104718143de_fine
delaine8314793delaine
dentine83320243dentine
depone93616553de_pone
depside1138403depside
desire7415303des_ire
despised1236923despised
despiser1136343despiser
despises1139433despises
despited1248323despited
despites11410313despites
despond1137513despond
destined103312453destined
destines93619663destines
destiny113111463destiny
elapine9310673elapine
empire1039323_empire
engine71114863_engine
eosine64519413_eosine
equine151711573_equine
ermine8416923_ermine
eserine7415903_eserine
esne47018793_es__ne
espial839543_espial
espied9359773_espied
espies83716803_espies
espying1336193_espying
exine125518493_e_xine
expire1538023_expire
eyeshine1444543eyeshine
fascine12510583fascine
feline94820143fe_line
ferine96422583fe_rine
fessing113812863fessing
festive1339773festive
gasping113714363gasping
genuine838373genuine
hasping134414903hasping
heaping133015853heaping
helping133512223helping
hemline12311073hemline
hempie132410563hempi_e
heroine103517483heroine
hessite1038993hessite
hospice14117063hospice
inspire938253inspire
jasmine1636643jasmine
jeeping174010333jeeping
jessing153710623jessing
jesting154317713jesting
keeping144012543keeping
kelpie12308613kelpi_e
kelping14319193kelping
kepping16268593kepping
kewpie15465413kewpi_e
leaping103215993leaping
leonine7311233leonine
leucine938073leucine
lisping103412753lisping
lupine84013533_lupine
lysine94210553lys_ine
meshing134513813meshing
mesne75116293mes__ne
messing103916393messing
mestino9411643mestino
muspike1536043muspike
nervine102510633nervine
nesting84320443nesting
neurine7311683neurine
opine77422463__opine
orpine83914483_orpine
oscine8311563_oscine
overmine13313663overmine
overspice1647123overspice
overspin1338203overspin_
overspins1439043overspins
peeping123615213peeping
pennine93712953pennine
pepino10310333pe_pino
pepping113511623pepping
pepsin10310853pepsin_
pepsines1239883pepsines
pepsins11310433pepsins
perspire1246663perspire
pine67755713___pine
piscine11610973piscine
propine113020213propine
rapine85023083_rapine
rasping104316253rasping
reaping103621213reaping
recline94020493recline
redline84218833redline
refine95225693re_fine
reline65434353re_line
repin75324703re_pin_
repined104918773re_pined
repiner94816903re_piner
repines94927383re_pines
repins84924313re_pins
repping123314983repping
rescind10410393rescind
reseize1639553reseize
reserpine1147523reserpine
reshined123011123reshined
reshines112615443reshines
reshone102414163reshone
reside74224933res_ide
resile64627673res_ile
resin54131053res_in_
resined84522653res_ined
resins64528773res_ins
resiny94617363res_iny
resite64128453res_ite
resize154117723res_ize
respace11310913respace
respade1039573respade
respired1148993respired
respires10311903respires
respited11410813respited
respites10513243respites
resplice1237253resplice
respoke134311283respoke
respond1039113respond
response1037753response
respring111614063respring
resting85031183resting
restive10315933restive
retine66237333re_tine
rexine134719443re_xine
rusine63916593rus_ine
seeping103817913seeping
seine55732873__seine
serine65432673se_rine
sessile739523sessile
sestina72711973sestina
sestines82717243sestines
setline7313923setline
shine85533093__shine
sine46560623__s_ine
spice95528813__spice
spike114922843__spike
spile75230083__spile
spin66231303__spin_
spined95423943__spined
spinel85317333__spinel
spines85132033__spines
spinet85629753__spinet
spins75327983__spins
spiny104921303__spiny
spire75828693__spire
spite75430663__spite
spline86020533__spline
supine84216693_supine
suspire937803suspire
swine85625303__swine
temping122710693temping
tenpin8310583tenpin_
tenpins9410073tenpins
terpene92310863terpene
terrine72517573terrine
testing86021053testing
tropine93116653tropine
ursine64114123urs_ine
vaccine1437323vaccine
vahine123612113v_ahine
valine94623093v_aline
vamping152810233vamping
vampire14296673vampire
vaseline1138613vaseline
vealing114217423vealing
veepee11311483veep_ee
veering113213683veering
veggie1136303veggi_e
vegging13308873vegging
vegie94614513ve_gi_e
veiling113615293veiling
vein75625753ve__in_
veined104413913ve__ined
veiner94514753ve__iner
veining114713893veining
veins84620493ve__ins
veiny115414363ve__iny
vending124015263vending
venene92912523ve_nene
venging123710943venging
venin85118663ve_nin_
venines103516613ve_nines
venins93816703ve_nins
venire93513693ve_nire
venting114218093venting
verbile1249863verbile
verdin103113023verdin_
verdins112812333verdins
verging123812303verging
verite94323443ve_rite
vermin113414523vermin_
versines112213823versines
versing112314193versing
vesica11157913ves_ica
vesicae12177703vesicae
vesicle12217923vesicle
vesper1138083vesp_er
vespers1239033vespers
vespertine1544663vespertine
vespiary1642743vespiary
vestee94319153ves_tee
vestiges1238243vestiges
vestings12359143vestings
vestlike1535393vestlike
vesture10310373vesture
vetoing11309053vetoing
vetting114216563vetting
vexing17479173ve_xing
vine75643683v___ine
visaing11279333visaing
viseing11299163viseing
vising103915873vis_ing
visive1257873vis_ive
vitrine102511363vitrine
weepie11258793weepi_e
weeping133613673weeping
westing115020273westing
wisping133711943wisping
yelping13317873yelping
yessing113210063yessing
zebrine1836463zebrine
zesting174515333zesting

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 Limit1340272707.14018771.3
3Display Results2702700.0962812.5
 (SQL Overall)1786912707.64223382.8
 
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.