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

174 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
overfly1624688(None) 
hoverfly2043001hoverfly
overly122411361over_ly
overply15227651overply
overtly13268981overtly
covertly1655762covertly
deerfly1443982deerfly
loverly1346972lover_ly
overall10411082overall
overbuy1545422overbuy
overcoy1536632overcoy
overdry1435902overdry
overfar13227942overfar
overfat132712282overfat
overfed142510252overfed
overfill1436312overfill
overfit132610962overfit
overflew1735592overflew
overflow1754922overflow
overfull1435922overfull
overholy17216672overholy
overjoy2034872overjoy
overlay132410832overlay
overpay15228262overpay
overplay16257552overplay
overwily1736662overwily
verily122616052_verily
aerily93017013_aerily
alderfly1542753alderfly
alertly1046793alertly
aversely1444853aversely
barfly14339653_barfly
clerkly1643573clerkly
coverall1347603coverall
deafly13389123_deafly
eerily92913563_eerily
evenly1236993eve_nly
every115215453ever__y
ferly115517353_fer_ly
fierily1339023fierily
firefly1635633firefly
inertly1038543inertly
leerily1037633leerily
liefly1266363lie_fly
loveably16175233loveably
lovelily1444333lovelily
lovely12339713love__ly
medfly1535223_medfly
merely111312593_merely
modernly1443843modernly
moveably18175543moveably
novelly1346513nove_lly
obesely1245113obesely
obversely1742823obversely
onery8414123oner__y
openly1137123ope_nly
operably1557093operably
orderly1135763order_ly
outfly1238273o_utfly
ovally12278443ov_ally
ovary1149113ovar__y
ovately1334433ovately
over77227343over___
overable13513573overable
overact12315043overact
overage11514053overage
overalls11410393overalls
overapt12312653overapt
overarm12239793overarm
overate10620963overate
overawe13511463overawe
overbed132811853overbed
overbet122716063overbet
overbid132710273overbid
overbig13237543overbig
overbill1337283overbill
overblew1636223overblew
overblow1645033overblow
overbold14208553overbold
overbusy1654013overbusy
overbuys1644833overbuys
overcall1337673overcall
overcold14208493overcold
overcut12310423overcut
overdid12199173overdid
overdo10128363over_do
overdog12106523overdog
overdub13154333overdub
overdue11138953overdue
overdye14126923overdye
overeasy1437153overeasy
overeat102620323overeat
overed102216623over_ed
overfast14249663overfast
overfear14247403overfear
overfeed15299443overfeed
overfills1545703overfills
overfish1737893overfish
overflies1539103overflies
overflood1644523overflood
overflown1843713overflown
overflows1845113overflows
overflying2045463overflying
overfond1537323overfond
overfoul1446223overfoul
overfree1439003overfree
overfund1535813overfund
overfussy1842133overfussy
overgild1336583overgild
overgilt1239623overgilt
overglad13116533overglad
overheld15197373overheld
overhold15219013overhold
overhot13411223overhot
overidle1248823overidle
overing111918053overing
overjoys2135183overjoys
overkill1535533overkill
overlap12239833overlap
overlax17238413overlax
overlays14239693overlays
overlet102619033overlet
overlie102615013overlie
overlit102714743overlit
overman12311463overman
overmany1647143overmany
overmelt13310713overmelt
overmen12311803overmen
overmild1436983overmild
overmilk1735553overmilk
overmix1935573overmix
overnew13268133overnew
overpays16248253overpays
overplan13258943overplan
overplays17287013overplays
overplot1338543overplot
overplus1336063overplus
overran10311663overran
overrule11149673overrule
overrun1038023overrun
overs85224793over__s
oversad11259963oversad
oversale11313873oversale
oversalt11312743oversalt
oversaw13268163oversaw
oversea102412113oversea
oversee102717603oversee
oversell1137473oversell
overset102821473overset
oversew132810833oversew
overslip1336323overslip
overslow1435693overslow
oversold12218933oversold
overstay1436733overstay
oversup1236043oversup
overt85630723over__t
overtalk1537073overtalk
overtax17257733overtax
overtip1238193overtip
overtop1237723overtop
overuse10310923overuse
overwary17197413overwary
overwet132013933overwet
pertly115312553_pertly
poverty1536433pover_ty
refly113914563_re_fly
severely1445303severely
soberly1236943sober_ly
sternly1037853sternly
termly1138433_termly
vealy115817773_ve_aly
verify153110163_verify
verity123714853_verity
very108025643_ver__y

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271746.18621666.2
3Display Results1741740.0802175.0
 (SQL Overall)1786911746.65626846.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.