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

242 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
overlay13241083(None) 
overlap12239831overlap
overlax17238411overlax
overlays14239691overlays
overly122411361overl_y
overpay15228261overpay
overplay16257551overplay
loverly1346972loverl_y
overall10411082overall
overbuy1545422overbuy
overcoy1536632overcoy
overdry1435902overdry
overeasy1437152overeasy
overeat102620322overeat
overfar13227942overfar
overfat132712282overfat
overfly16246882overfly
overglad13116532overglad
overjoy2034872overjoy
overlade12611552overlade
overlaid122410382overlaid
overlain112112442overlain
overland122312002overland
overlaps13219522overlaps
overlate11716282overlate
overleaf14237972overleaf
overleap13237832overleap
overlet102619032overlet
overlie102615012overlie
overlit102714742overlit
overload12119282overload
overman12311462overman
overmany1647142overmany
overpays16248252overpays
overplan13258942overplan
overplays17287012overplays
overply15227652overply
overran10311662overran
oversad11259962oversad
oversaw13268162oversaw
overstay1436732overstay
overtax17257732overtax
overtly13268982overtly
overwary17197412overwary
avellan1037293avellan
belay105021523_be_lay
coverall1347603coverall
coverlet13413013coverlet
coverlid1445943coverlid
covertly1655763covertly
delay94820633_de_lay
deray95024183_der_ay
evenly1236993evenl_y
every115215453ever__y
everyday1841833everyday
everyway2041933everyway
ferly115517353_ferl_y
foreplay1645673foreplay
foveola13115013foveola_
foveolae14104323foveolae
foveolar1493743foveolar
foveolas14135113foveolas
hoverfly2043003hoverfly
interlay11310043interlay
lovely12339713love_l_y
novella1076213novella_
novellas1176343novellas
novelly1346513nove_lly
novelty1365173nove_lty
novercal1345683novercal
ocellar936533ocellar
onery8414123oner__y
onlay84212943o__nlay
openly1137123openl_y
opera7313573oper_a_
operas8312453oper_as
orderly1135763orderl_y
orfray1234393orfr_ay
outlay92711793o_utlay
outplay12267723outplay
ovally12278443ov_ally
ovarial1037613ovarial
ovarian1037643ovarian
ovary1149113ovar__y
over77227343over___
overact12315043overact
overage11514053overage
overalls11410393overalls
overapt12312653overapt
overarm12239793overarm
overate10620963overate
overawe13511463overawe
overbake17129803overbake
overbear13228883overbear
overbeat132713833overbeat
overbed132811853overbed
overbet122716063overbet
overbid132710273overbid
overbig13237543overbig
overblew1636223overblew
overblow1645033overblow
overbusy1654013overbusy
overbuys1644833overbuys
overcall1337673overcall
overcame151310693overcame
overcast132411973overcast
overclaim1645333overclaim
overclass1436963overclass
overclean14115263overclean
overclear14134743overclear
overcoat13312103overcoat
overcram1537073overcram
overcut12310423overcut
overdare12311183overdare
overdear12248083overdear
overdid12199173overdid
overdo10128363over_do
overdog12106523overdog
overdraw1535803overdraw
overdub13154333overdub
overdue11138953overdue
overdye14126923overdye
overeats112415263overeats
overed102216623over_ed
overfast14249663overfast
overfear14247403overfear
overfed142510253overfed
overfit132610963overfit
overflew1735593overflew
overflow1754923overflow
overglaze2286273overglaze
overgoad13127153overgoad
overhand15229963overhand
overhang15248863overhang
overhard15238793overhard
overhasty1843763overhasty
overhate14312793overhate
overhaul1436223overhaul
overhead152110363overhead
overheap16257343overheap
overhear14249413overhear
overheat142413773overheat
overholy17216673overholy
overhot13411223overhot
overing111918053overing
overjoys2135183overjoys
overlabor1443963overlabor
overladed1459223overladed
overladen1367643overladen
overlades13510353overlades
overlands13218883overlands
overlarge1346823overlarge
overlaying1738443overlaying
overleaps14226783overleaps
overleapt14247883overleapt
overlearn1235903overlearn
overlend122510103overlend
overlent112715293overlent
overlets112312363overlets
overlewd15216273overlewd
overlies112417043overlies
overlive142211293overlive
overloads13127663overloads
overlong1238123overlong
overlook1596423overlook
overlord12119183overlord
overloud12117753overloud
overlove14239173overlove
overlush1445273overlush
overmans13310313overmans
overmen12311803overmen
overmix1935573overmix
overnear11238473overnear
overneat112713643overneat
overnew13268133overnew
overpack1966623overpack
overpaid14158933overpaid
overpass13258653overpass
overpast132611023overpast
overplaid1546813overplaid
overplans14249573overplans
overplant142510713overplant
overplayed19206763overplayed
overplot1338543overplot
overplus1336063overplus
overrank1548113overrank
overrash1436953overrash
overrate11615693overrate
overrun1038023overrun
overs85224793over__s
oversale11313873oversale
oversalt11312743oversalt
oversave14310493oversave
oversea102412113oversea
overseas112612423overseas
oversee102717603oversee
overset102821473overset
oversew132810833oversew
overslip1336323overslip
overslow1435693overslow
oversoak1536993oversoak
overstays1535943overstays
oversup1236043oversup
overt85630723over__t
overtake151210143overtake
overtalk1537073overtalk
overtame131510523overtame
overtart11312493overtart
overtask1535773overtask
overtip1238193overtip
overtop1237723overtop
overuse10310923overuse
overwarm16236933overwarm
overweak18216073overweak
overwear14248603overwear
overweary18255413overweary
overwet132013933overwet
overwily1736663overwily
overzeal2076093overzeal
ovular946833ov_ular
ovulary1344913ov_ulary
parlay113713993_parlay
poverty1536433pover_ty
relay84424673_re_lay
replay113412923_replay
soberly1236943soberl_y
superlay1347753superlay
underlay12147653underlay
vealy115817773_veal_y
veejay1933703_veejay
vela75725543_ve_la_
velar85817633_ve_lar
vera76828843_ver_a_
verbal112513663_verbal
verglas1137813_verglas
verify153110163_verify
verily122616053_verily
verity123714853_verity
vernal93514213_vernal
versal93013753_versal
very108025643_ver__y
virelay1335943_virelay

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.420425454.8
2DLD Change Limit1340272426.83019623.3
3Display Results2422420.0932602.2
 (SQL Overall)1786912427.34324334.9
 
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.