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

188 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
oscula83729(None) 
oscular937941oscular
oscule838191oscule
bacula103112692bacula
facula112912232facula
fecula113310052fecula
macula103013672macula
occult1038432occult
ocular8610142o_cular
oculi72010792o_culi
opuscula1242792opuscula
osculant1046952osculant
osculate101010612osculate
oscules938122oscules
osculum1143832osculum
scuba94211592_scuba
sculk115112462_sculk
scull75315762_scull
sculp95314842_sculp
scuta75815752_scuta
vascula1245852vascula
acicula11228133acicula
alula5317093_alula
ascus75013583ascu_s
asyla839333as_yla
aucuba1045493aucuba
bascule1136573bascule
canula8312973canula
cedula977643cedula
cicala10310063cicala
coagula1045413coagula
cola66541393__cola
copula102812053copula
cull65929643__cull
culm85822383__culm
culpa93610963__culpa
cult66541153__cult
cupula10328443cupula
doula65717773_doula
escolar946053escolar
escudo943373escudo
faculae123210353faculae
facular122810453facular
feculae12339203feculae
ferula93011173ferula
fibula11258053fibula
fistula1045503fistula
formula1246293formula
furcula1245803furcula
hula74923753__hula
incult82414773incult
inocula947273inocula
insculp1143793insculp
ischia1136393ischia
jocular1637313jocular
jugula1434983jugula
lacuna8118123lacuna
ligula7359673ligula
locular938963locular
locule83412033locule
loculi8288253loculi
lunula636173lunula
maculae113412863maculae
macular113011953macular
maculas113114023maculas
macule104115273macule
morula8710473morula
muscular1246253muscular
nebula857333nebula
noncola948303noncola
obscure1145333obscure
oca56731733o_c__a
occults1135123occults
occupy1543153occupy
occur9137323occu_r
occurs10136553occurs
ocrea73311823o_crea
octal71214723o_ctal
oculars948363o_culars
oculus8178393o_culus
olla44821173o__lla
opercula1244993opercula
opuscular1343283opuscular
opuscule1242823opuscule
oracular1047543oracular
orca65522773orc__a
oscine8311563oscine
osculated1298143osculated
osculates11109393osculates
osetra667423osetra
osmol7138573osmol_
osmolal944393osmolal
osmolar944483osmolar
osmole8128513osmole
osmols8137313osmols
osmund933803osmund
osmunda1041653osmunda
ossa43714163os__sa
ossia53710403os_sia
ossicular1144093ossicular
osteal6312963osteal
ostia52315583os_tia
ovular946833o_vular
ovule839493o_vule
papula103011123papula
peculia1147133peculia
picul95015363picul_
piculs103511753piculs
psylla1133953psylla
pula65129373__pula
radula749313radula
ranula6311813ranula
roseola777053roseola
saul45836523_saul_
sauls55128123_sauls
sault55834963_sault
sauna54117553_sauna
scalar83612443_scalar
scald84818123_scald
scale74629143_scale
scall74420373_scall
scalp95217983_scalp
scaly104718723_scaly
scapula1136353_scapula
scena74815783_scena
schul102510413_schul_
schuln11256233_schuln
schuls11299853_schuls
schwa13426843_schwa
scilla8310943_scilla
scold85414863_scold
scopula1155003_scopula
scubas103710223_scubas
scud76221283_scu_d
scudi85112163_scudi
scudo85412213_scudo
scuds85116243_scuds
scuff133914893_scuff
sculch13226213_sculch
sculks123610263_sculks
sculls84613883_sculls
sculps104611753_sculps
sculpt104412693_sculpt
scum85924523_scu_m
scums95017423_scums
scup84822383_scu_p
scups95316653_scups
scurf104719323_scurf
scut65835543_scu_t
scute75520943_scute
scuts74522523_scuts
scuzz1537573_scuzz
secular92211543secular
shul75823153_shul_
shuln84713113_shuln
shuls85319713_shuls
sigla64515203_sigla
skua86113153_sku_a
skulk8479623_skulk
skull94812033_skull
soca66330053soc__a
social8813333social
socle7419573soc_le
sola45541863_s_ola
soul46435713_soul_
souls55127363_souls
specula11187423specula
spicula11259303spicula
sputa74612963_sputa
stela54019043_stela
stull54916273_stull
stupa74112313_stupa
suba64926603_s_uba
sulfa8313923_s_ulfa
sulk85326653_s_ulk
sulu45128423_s_ulu
sura45740293_s_ura
torula6610393torula
tsuba745563ts_uba
ungula737603ungula
usual5310183us_ual
uvula845153_uvula
vacua10510463vacu_a
vascular1346303vascular
vesicula1345223vesicula
vicuna11115903vicuna
vincula1246403vincula
zonula1537223zonula

Search took 9 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.406440125.6
2DLD Change Limit1127161887.65614722.6
3Display Results1881880.0603133.3
 (SQL Overall)1786911888.12222000.9
 
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.