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

359 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
foveal123770(None) 
fovea11310481fovea_
foveae1237561foveae
foveas1238621foveas
boreal84817212boreal
coeval1138892coeval
favela1237032favela
feal713940422f__eal
foal76630922fo__al
focal104917672fo_cal
foetal9311882foetal
fontal9313142fontal
formal113215202formal
foveate1338362foveate
foveola13115012foveola
foveole13106872foveole
hovel115017682hove_l
jovial1636542jovial
loreal63814312loreal
novel85615992nove_l
oval77119522_ov_al
reveal94115052reveal
uveal84411072_uveal
veal76936812__veal
zoeal144813782zo_eal
anneal64812293anneal
aortal65217513aortal
apneal83411123apneal
apogeal1045613apogeal
appeal103911613appeal
areal55928733_areal
arval86017013arv_al
avowal1246323avowal
bevel104517043beve_l
bohea105013733bohea_
boheas114013213boheas
boral75831703bo_ral
boreas85421733boreas
botel75121863bote_l
bowel105621203bowe_l
caveat11417723caveat
cereal8315833cereal
choreal124412223choreal
coaeval1245183coaeval
coal66939253co__al
coaxal15387303coaxal
coccal9310223coccal
coevals1237873coevals
cohead123811123cohead
coital84117053coital
colead94114643colead
comal95125133co_mal
conceal113313013conceal
congeal104011683congeal
copal95621783co_pal
coral76033453co_ral
corneal94414503corneal
corral83616253corral
costal85419513costal
coteau8311083coteau
cove95837073cove__
coved115027373cove_d
coven106925043cove_n
covens114919263covens
cover105430773cove_r
coverall1347603coverall
covers114627963covers
covert114925503covert
coves105539173cove_s
covet105638943cove_t
covets114819643covets
covey136121783cove_y
coveys145413503coveys
coxal146116673co_xal
cuneal8611513cuneal
deal56347413__deal
devel94217123deve_l
dogear838193dogear
domal85619203do_mal
dorsal74613943dorsal
dossal75510303dossal
dotal64919623do_tal
dove85131563dove__
doven94718553dove_n
dovens104413903dovens
doves94728153dove_s
dovetail1244393dovetail
dowel95618193dowe_l
facial113615633facial
faecal11359813faecal
fallal93612693fallal
farfal123410183farfal
fatal84819373f_atal
faucal11339963faucal
faunal94711593faunal
fava106820263fav_a_
favas115618593fav_as
fave105532963fave__
favelas1337023favelas
favella1336173favella
faves115331423fave_s
fear75337793f__ear
feat76458223f__eat
fecal105119213f_ecal
fecial114714623fecial
federal1148533federal
feel75233843f__eel
fell76833073f__ell
feral85424653f_eral
ferial94621253ferial
festal94213563festal
fetal85623373f_etal
fetial95716193fetial
feudal1037683feudal
fever115617953feve_r
fevers125414893fevers
filial93013253filial
final83922033f_inal
finial92814183finial
fiscal1139333fiscal
five107629743five__
fiver116024943five_r
fivers124420923fivers
fives116027363five_s
flea75628493f_lea_
fleam106017283f_leam
fleas86423663f_leas
floral94313813floral
fluvial1345363fluvial
foals85721693fo__als
foam97127173fo__am
fodgel1136403fodgel
foe66350813fo_e__
foehn11236323fo_ehn
foeman11311233foeman
foes76543443fo_e_s
fogey125617873foge_y
fogeys13509263fogeys
foil76433913fo__il
foley115222303fole_y
foleys123810463foleys
folia83618933folia_
foliar93210973foliar
foment113718303foment
fool75330593fo__ol
fora75937393fo_ra_
foram105124933fo_ram
foray115023973fo_ray
forbad122710503forbad
forbear1237523forbear
fore78351473fore__
forearm1238693forearm
forebay1538133forebay
foreby1438633foreby
foredo10510823foredo
forego1038903forego
foreman12312363foreman
forepaw1595613forepaw
foreran10311793foreran
fores85847103fore_s
foresail1147823foresail
foresaw1377133foresaw
forest94926743forest
forestal11410283forestal
forgat104018583forgat
formals123312893formals
format113021353format
formol112910333formol
formyl14276443formyl
fossa85812633fossa_
fossae95510373fossae
fossas94610703fossas
fossil9379353fossil
foul77027583fo__ul
foveated1536293foveated
foveolae14104323foveolae
foveolar1493743foveolar
foveolas14135113foveolas
foveoles1496643foveoles
foveolet14107543foveolet
fowl105723633fo__wl
foxed165115213foxe_d
foxes156321093foxe_s
foxtail1745383foxtail
foyer116416553foye_r
foyers125413133foyers
freak125115243f_reak
frontal1038363frontal
frugal1036393frugal
fuel76824733f_ue_l
fugal95613033f_ugal
funeral1037623funeral
fungal10388733fungal
fusel85218493fuse_l
gavel95815183gave_l
gavial10310083gavial
goal55829303go__al
gomeral1038833gomeral
gooral7310463gooral
goral65125753go_ral
govern1036823govern
grovel104310543grove_l
heal75645693__heal
horal86328673ho_ral
hosel86024813hose_l
hotel85520743hote_l
hove107132223hove__
hovels125413333hovels
hover115524133hove_r
hovers124320253hovers
ideal65716393_ideal
ileal56118083_ileal
irreal657823irreal
joual12311653jo_ual
juvenal1743393juvenal
kevel124213093keve_l
koel84519943ko_e_l
kvell12436693_kvell
leal46043273__leal
level84116553leve_l
lineal65616023lineal
local74820273lo_cal
loral55927823lo_ral
losel54419423lose_l
lovat8321043lov_at
love75234763love__
loveable13187903loveable
loveably16175233loveably
loved95021363love_d
lovely12339713lovely
lover85526453love_r
loverly1346973loverly
lovers94223433lovers
loves85332013love_s
loyal84513483lo_yal
luteal64411483luteal
meal65643173__meal
modal85919233mo_dal
model84521693mode_l
mohel104914833mohe_l
molal75120343mo_lal
moral75533433mo_ral
morel75729093more_l
mortal84616853mortal
motel76623243mote_l
move96630723move__
moveable15168013moveable
moveably18175543moveably
moved114218153move_d
mover104220863move_r
movers115117193movers
moves106128423move_s
naval85315833nav_al
navel87016573nave_l
nival84915773niv_al
nodal64717793no_dal
noel45226553no_e_l
nopal75517103no_pal
normal83213533normal
notal55221353no_tal
nounal639813nounal
nouveau1043953nouveau
nova76518953nov_a_
novae85913123nov_ae
novas85215363nov_as
novella1076213novella
novelle1058233novelle
novelly1346513novelly
novels95512503novels
novena936763novena
novenae1046323novenae
novenas1036893novenas
novercal1345673novercal
obeah1038993_obeah
ocean71212963_ocean
octal71214723_octal
odea56224573_odea_
offal1136243_offal
olea46532723_olea_
opal66923523_o_pal
oral47638123_o_ral
ordeal779253ordeal
oread64619603_oread
osteal6312953osteal
ova66823793_ov_a_
ovals85413393_ov_als
oven76624143_ove_n
ovens86217453_ovens
over77227343_ove_r
overall10411083_overall
overly122411363_overly
overs85224793_overs
overt85630723_overt
paleal84716673paleal
peal68648103__peal
pineal84817683pineal
poleax1547993poleax
portal84218463portal
postal84317533postal
ravel84621513rave_l
real45750293__real
repeal84718283repeal
reseal64819643reseal
reveals103812723reveals
revel84423163reve_l
rival85216503riv_al
rove75136983rove__
roved95323553rove_d
roven85521973rove_n
rover85527373rove_r
rovers95423523rovers
roves84834483rove_s
rowel84721413rowe_l
royal85014703ro_yal
seal45654373__seal
several1039533several
sheal84927703_sheal
shovel124611313shove_l
social8813333social
sorel56231443sore_l
sovran937153sovran
squeal1538013squeal
steal56125473_steal
teal45546503__teal
tineal66216153tineal
toea46732333to_ea_
toeas55726423to_eas
tombal102311023tombal
tonal53724303to_nal
total55321823to_tal
towel84920523towe_l
unreal64414453unreal
unseal63315473unseal
unveil957343unveil
ureal56722683_ureal
uvea74712653_uvea_
uveas84912283_uveas
veals84926193__veals
vealy115817773__vealy
veil75523593__veil
vela75725543__vela
venal85523213__venal
vial76731093__vial
vineal94814743vineal
vocal104715643vo_cal
vowel115515013vowe_l
weal75838683__weal
wheal115716183_wheal
wove105624313wove__
woven115215173wove_n
wovens12449833wovens
yodel94714083yode_l
yokel124812613yoke_l
zeal135530333__zeal
zoea137118423zo_ea_
zoeae144412483zo_eae
zoeas145815613zo_eas
zonal145116853zo_nal
zoonal1558083zoonal

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.1431249587.4
2DLD Change Limit1127163595.39020912.1
3Display Results3593590.1103263.6
 (SQL Overall)1786913595.64331666.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.