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

220 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
jayvee195761(None) 
jaygee1759461jaygee
jayvees2052921jayvees
jarvey19135402jarvey
jaygees1854512jaygees
payee105524722pay_ee
ackee115825363_ackee
agee56241493_a_gee
aglee65728493_aglee
agree65226033_agree
aiver85725163_aiver
ajee115928233_a_jee
akee85936813_a_kee
alee46652323_a_lee
allee54932123_allee
ave67748703_a_v_e
aver75931883_a_ver
aves76142603_a_ves
awee76336643_a_wee
aye67151763_ay__e
ayes76543513_ay_es
bailee84526013bailee
bargee94624443bargee
baubee103215993baubee
bawbee132714233bawbee
bayed115423023bay_ed
baymen134212003baymen
callee84327293callee
calve105919923calv_e
calved125215453calved
calves115119283calves
carve106227753carv_e
carved124320853carved
carvel114817573carvel
carven114716663carven
carver114420143carver
carves115128453carves
cave95941263ca_v_e
caved116227563ca_ved
caver105629063ca_ver
caves105639703ca_ves
cavie104621593ca_vie
cayuse11207763cayuse
corvee114320093corvee
cuvee10316143_cuvee
daven94916473da_ven
daybed13438673daybed
eave75733583ea_v_e
eaved95924503ea_ved
eaves85231993ea_ves
fauve114712073fauv_e
fauves125610423fauves
fave105532963fa_v_e
faves115331423fa_ves
fayed126422153fay_ed
garvey13127873garvey
gave84634053ga_v_e
gavel95815183ga_vel
gayer94519193gay_er
gyve116215083_gyv_e
gyved13568743_gyved
gyves125711553_gyves
hackee154921833hackee
hadjee174111823hadjee
halve114818923halv_e
halved134813903halved
halves124717093halves
have106137073ha_v_e
haven114718533ha_ven
haver115124463ha_ver
haves116034873ha_ves
hayed125822013hay_ed
hayer114620243hay_er
hayey144812533hay_ey
hayseed1435633hayseed
humvee1439203humvee
jabbed184213483jabbed
jabber173713643jabber
jacked204817523jacked
jacker194417583jacker
jacket194720673jacket
jade125325443ja__de
jaded144417033ja_ded
jades135222113ja_des
jaeger14397193jaeger
jager134318133ja_ger
jagged164115353jagged
jagger154016003jagger
jailed144917423jailed
jailer134316683jailer
jake155925773ja__ke
jakes165023643ja_kes
jambe165314753ja_mbe
jambed184811403jambed
jambes175914053jambes
jammed183811503jammed
jammer174014133jammer
jane115031483ja__ne
janes124928123ja_nes
jangle144416293jangle
jape134923423ja__pe
japed156217633ja_ped
japer146218883ja_per
japes146322823ja_pes
jarred144613253jarred
jarveys20123413jarveys
jasper154610383jasper
jauked18489013jauked
jaunce15367433jaunce
jauped16457903jauped
java147316643ja_v_a
javas155915423ja_vas
jawed165517373ja_wed
jay136242673jay___
jays146328343jay__s
jazzed22416293jazzed
jazzer21376503jazzer
jazzes21347883jazzes
jee106648643j___ee
jinnee13411573jinnee
jive146123593j_iv_e
jived165115043j_ived
jiver155119053j_iver
jives154820813j_ives
jivey185111873j_ivey
joyed164811833joy_ed
kayles134712003kayles
kayoed14416903kayoed
kayoes134710823kayoes
laree56036293la_ree
larvae938843larvae
lave75642143la_v_e
laved95028593la_ved
laveer94110423la_veer
laver85031793la_ver
laves86039153la_ves
layed95127383lay_ed
layer84626473lay_er
laymen113010843laymen
layover1334433layover
levee84023813_levee
lycee104716743_lycee
mallee84525593mallee
mammee94417853mammee
marvel113712003marvel
mauve104013273mauv_e
mauves113811553mauves
maven104816893ma_ven
mavie104722563ma_vie
maybe12311133may_be
maybes1339243maybes
mayed115522403may_ed
mayhem1644923mayhem
mayvin1436523mayvin
mayweed1634163mayweed
naive85116213naiv_e
naiver94311353naiver
naives94914223naives
naivete1055663naivete
nave75732313na_v_e
navel87016573na_vel
naves87030383na_ves
oaves84925613oa_ves
pardee93922023pardee
pareve114613013pareve
parve109824853parv_e
passee84522023passee
pattee84323383pattee
pave96133893pa_v_e
paved115525263pa_ved
paveed12438893pa_veed
paver104225833pa_ver
paves104833923pa_ves
pawnee113115403pawnee
payed115925933pay_ed
payees114812903payees
payer105125723pay_er
ragee65432663ra_gee
raggee84217603raggee
rakee96031173ra_kee
ramee74633853ra_mee
ranee55438103ra_nee
rappee103618673rappee
rave75542093ra_v_e
raved94931433ra_ved
ravel84621513ra_vel
raven84723443ra_ven
raver85631493ra_ver
raves85441973ra_ves
rayed95127503ray_ed
razee145827803ra_zee
salve85022133salv_e
salved103916423salved
salver94617753salver
salves94221763salves
saree55044663sa_ree
save75741363sa_v_e
saved95127113sa_ved
saver84831253sa_ver
saves85838633sa_ves
sayed96127143say_ed
sayer84926553say_er
sycee105018623_sycee
tyee75131423_ty_ee
valve114515933valv_e
valved136711043valved
valves124113783valves
varve115716853varv_e
varved134110603varved
varves124414783varves
vee65750183___vee
waive114214603waiv_e
waived134511283waived
waiver124212713waiver
waives123714183waives
wave105234733wa_v_e
waved125223583wa_ved
waver115025703wa_ver
waves115633923wa_ves
wavey145115543wa_vey

Search took 6 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.1231452772.4
2DLD Change Limit1127162205.59620142.2
3Display Results2202200.0633492.1
 (SQL Overall)1786912205.78230904.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.