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

200 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
ovular94683(None) 
ocular8610131ocular
ovulary1344911ovulary
uvular955561uvular
alular6311352alular
anovular1144162anovular
biovular1343602biovular
copular113810602copular
gular6314832_gular
jocular1637302jocular
lobular936662lobular
locular938952locular
modular1087362modular
morular978222morular
nodular876702nodular
oculars948362oculars
oscular937932oscular
ovulate1039452ovulate
ovule839492ovul_e
ovules938222ovules
popular11319562popular
uvula845152uvula_
uvulae945322uvulae
uvulars1044412uvulars
uvulas946522uvulas
velar85817632_velar
volar86917412_volar
vulgar10426822_vulgar
vulvar12427962_vulvar
zonular1656492zonular
alar46340073__alar
alula5317093alula_
alulae6312743alulae
angular838533angular
annular737693annular
ashlar9338193ashlar
aurar54420253_aurar
avatar937523avatar
avicular13237273avicular
avulse935843avulse
bolar75123473_bolar
bulbar1039583_bulbar
canular9310323canular
cellar84514983cellar
chukar1534633chukar
collar83816173collar
consular1038813consular
copula102812043copula_
copulae112810613copulae
copulas113811563copulas
coruler9311713coruler
cougar958783cougar
cupular11317623cupular
dollar74110983dollar
doula65717773doula_
doulas75114993doulas
eviler94811893eviler
evulse935213evulse
fabular12288693fabular
facular122810443facular
feuar8310243feu_ar
fibular12267973fibular
filar84819293_filar
foulard11257283foulard
fouler93614903fouler
foveolar1493743foveolar
fubar1039923_fubar
fulmar1137253_fulmar
globular1143383globular
guar56923293_gu_ar
gulag7310823_gulag
hamular1236973hamular
hauler95015123hauler
hilar85418143_hilar
hula74923753_hula_
hulas84920883_hulas
insular7138703insular
jugular1534513jugular
kulak858823_kulak
lar37967533___lar
ligular8348533ligular
lunar57017313_lunar
lunular736013lunular
macular113011943macular
malar76424443_malar
mauler84416713mauler
medlar93010463medlar
modulars1165833modulars
molar75223093_molar
monovular1443303monovular
morula8710473morula_
morulae958963morulae
morulas959703morulas
mutular936643mutular
mylar105311533_mylar
nebular956483nebular
oar37057953o___ar
ocellar936533ocellar
ocularly1374643ocularly
oculi72010793ocul_i
oculus8178393oculus
ogler65917443o_gler
oiler54628283o_iler
olla44821173o_lla_
ollas54218283o_llas
onlay84212943o_nlay
oracular1047533oracular
osar46820953o__sar
oscula837293oscula_
osmolar944483osmolar
ostler63312193ostler
ottar54313993o_ttar
our36042893o_u__r
ourari63413543o_urari
outer55633303o_uter
outlaw9279643outlaw
outlay92711793outlay
outwar91011513outwar
ova66823793ov__a_
oval77119523ov__al
ovally12278443ovally
ovals85413393oval_s
ovary1149113ov__ary
over77227343ov__er
overarm12239793overarm
overfar13227943overfar
overlap12239833overlap
overlax17238413overlax
overlay132410833overlay
ovipara1242543ovipara
ovisac1153953ovisac
ovoli8358283ovol_i
ovolo8339173ovol_o
ovolos9257203ovolos
ovulated1237083ovulated
ovulates1148523ovulates
ovulatory1544833ovulatory
ovum92310173ovu__m
pabular11259473pabular
papular11299763papular
pedlar93311273pedlar
phylar14437373phylar
pilar75221503_pilar
pillar8314023pillar
pilular938203pilular
polar75623453_polar
poplar103611113poplar
poulard10299733poulard
pula65129373_pula_
puler74826623_puler
pulsar8329363_pulsar
radular837833radular
ranular739433ranular
regular838423regular
ruler54923343_ruler
scalar83612433scalar
secular92211533secular
simular938673simular
solar55927343_solar
solunar735283solunar
soucar839323soucar
sporular1065223sporular
stelar64013863stelar
stylar9358113stylar
sugar6312913_sugar
tabular9279763tabular
talar56225383_talar
tegular836603tegular
titular737523titular
tolar55524113_tolar
torula6610393torula_
torulae758553torulae
torulas759843torulas
tubular9267473tubular
tumular9236543tumular
ulan46527393__ulan
ulnar56013983__ulnar
undular837123undular
ungular836773ungular
uvularly1442693uvularly
valor83614893_valor
valvar12388653_valvar
valvular1443463valvular
var66148333_v__ar
vela75725543_vela_
velars93913723_velars
venular1037683venular
vicar10513863_vicar
viler86324163_viler
voila84813943voila_
vulgars11306533_vulgars
vulgo936953_vulgo
vulva11448803_vulva
vulvae12438033_vulvae
vulval12417663_vulval
vulvas12388843_vulvas
yulan8411493_yulan
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

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.1401276364.3
2DLD Change Limit1127162006.34317770.1
3Display Results2002000.0762631.6
 (SQL Overall)1786912006.55927243.6
 
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.