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

229 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
vespid124608(None) 
vespids1334611vespids
cuspid11429212cuspid
desmid1048362desmid
espied9359772_espied
hispid1238172hispid
resaid74517082resaid
resid64124092res_id
tepid8314312te_pid
vapid115614282v_apid
verbid122311312verbid
vesper1138082vesper
vespine1237902vespine
vested104217352vested
viscid1237472viscid
aspic95114733_aspic
aspis74618143_aspis
bedrid1039943bedrid
beeped115313453beeped
beside95114613bes_ide
bested94922763bested
bestir8311163bestir
bestrid1039973bestrid
bestud9439303bestud
capsid11312413capsid
cebid104314073ce_bid
ceboid11310653ceboid
cervid1239323cervid
cessed94615613cessed
cesspit1145463cesspit
cesti75217423cesti_
cestoid104011673cestoid
cosmid11810643cosmid
cupid103212783_cupid
cusped114312043cusped
cuspids12427113cuspids
cuspis105010703cuspis
depside1138403depside
desand84812633desand
desmids1166603desmids
desmoid1137103desmoid
despair1045463despair
despise1038683despise
despised1236923despised
despite10410123despite
despited1248323despited
despoil1046523despoil
despond1137513despond
despot93413293despot
devoid1189363devoid
elapid939543elapid
epic86921303_e_pic
equid154610323_equid
espial839543_espial
espies83716803_espies
esprit8312843_esprit
espy969373_esp_y
felid94717173fe_lid
fervid1337513fervid
fessed104515063fessed
fetid93715983fe_tid
gasped104814293gasped
gelid74916983ge_lid
geoid74215763ge_oid
gestic9312773gestic
hasped125014443hasped
heaped124516903heaped
helped124714153helped
hemoid12313513hemoid
hempie132410563hempie
insipid1044513insipid
jassid1467223jassid
jeeped16469843jeeped
jerid132316423je_rid
jerrid14259143jerrid
jessed144112303jessed
jested144416503jested
jesuit1339583jesuit
keloid11812623keloid
kelped13449553kelped
kelpie12308613kelpie
kepi105315633ke_pi_
kepis115313363ke_pis
kepped15309543kepped
kewpie15465413kewpie
keypad1633823keypad
leaped94317773leaped
limpid11389753limpid
lipid85916173_lipid
lisped94113423lisped
masjid16187323masjid
meloid9616003meloid
meshed124415933meshed
mesic93617863mes_ic
messed95018183messed
misdid10510573misdid
muscid11219833muscid
musjid16216953musjid
mysid11610693mys_id
nereid7312923nereid
nested74720063nested
nevoid1098793nevoid
overbid132710273overbid
overdid12199173overdid
overpaid14158933overpaid
overspin1338203overspin
peeped113915393peeped
pepped103113403pepped
pepsin10310853pepsin
peptid112712373peptid
rapid86422033_rapid
rasped94715203rasped
reaped94122453reaped
rebid85121363re_bid
redid74922393re_did
relaid75518443relaid
repaid94716323repaid
repin75324703re_pin
repped114616723repped
resail64418733resail
rescind10410393rescind
reseed74823293reseed
resend75016773resend
reship11310673reship
reshod103012233reshod
reside74224933res_ide
resids74219153res_ids
resin54131053res_in
resit54241043res_it
resod64720053res_od
resold73915363resold
respade1039573respade
respire9411543respire
respired1148993respired
respite9513033respite
respited11410813respited
resplit9310373resplit
respond1039113respond
respot83117633respot
rested74430783rested
said55742113__said
salpid9510883salpid
sapid84720933_sapid
seeped94317523seeped
sepia75318673se_pia
sepic94617053se_pic
sepsis83011293sepsis
skid95720933__skid
slid55828983__slid
sped76031493__sped
spic85227433__spic
spied85427713__spied
spik105419713__spik
spin66231303__spin
spit65545083__spit
spiv95917793__spiv
spud75818493__spud
stupid937593stupid
teiid6312533te_iid
temped113912893temped
tempi94912203tempi_
tenpin8310583tenpin
tested74421523tested
testis64916713testis
torpid9310913torpid
trepid9310083trepid
unsaid7411833unsaid
ursid6311483urs_id
valid94618393v_alid
vamped144211013vamped
vealed103916323vealed
veep95325093veep__
veepee11311483veepee
veeps104715723veep_s
veered103612743veered
vegged124910023vegged
veggie1136303veggie
vegie94614513ve_gie
veil75523593ve__il
veiled103714543veiled
vein75625753ve__in
veined104413913veined
veld85323203ve__ld
vend86626423ve__nd
vended114416353vended
venged114011993venged
venin85118663ve_nin
vented104617923vented
verbids13259203verbids
verdin103113023verdin
verged114815163verged
vermin113414523vermin
vermis114214963vermis
vernix1636633vernix
versed104515513versed
vesica11157913vesica
vespers1239033vespers
vespiary1642743vespiary
vessel937953vessel
vest75743603ves__t
vesta86618303ves_ta
vestal94615573vestal
vestas95916683vestas
vestee94319153vestee
vestige1137433vestige
vesting114618683vesting
vestry1238623vestry
vests85325983ves_ts
vetoed10359823vetoed
vetted104316323vetted
vexed165713113ve_xed
vexil1538963ve_xil
vid77241813v___id
virid94116043v_irid
viroid10411523viroid
visaed104110503visaed
visard103910123visard
viscoid1337023viscoid
vised95518763vis_ed
viseed105310983viseed
visit8320963vis_it
vivid125112313v_ivid
void86220563v__oid
weepie11258793weepie
weskit1338343weskit
wisped123411893wisped
yelped12439363yelped
yessed104511163yessed
zested164214043zested

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162295.76619548.4
3Display Results2292290.0763013.2
 (SQL Overall)1786912296.24828599.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.