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

210 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
oculars94836(None) 
ocular8610141ocular_
collars93816572collars
cougars1038442cougars
jocular1637312jocular_
locular938962locular_
modulars1165832modulars
ocularist1177322ocularist
ocularly1374642ocularly
oculus8178392ocul_us
oscular937942oscular_
ovular946832ovular_
ovulary1344912ovulary
scalars93711912scalars
seculars10219402seculars
uvulars1044412uvulars
aculeus937513aculeus
alular6311363alular_
ashlars10297063ashlars
binoculars1463173binoculars
calcars11312653_calcars
cars67364763_c__ars
cedars93312833_cedars
cellars93713693cellars
chars105936643_c_hars
chukars1634283chukars
cigars9910723_cigars
circulars1346543circulars
clads85722733_c_lads
clags85621123_c_lags
clams95127673_c_lams
clans75031013_c_lans
claps95626183_c_laps
claro75018693_c_laro
claros84015113_c_laros
clary105719613_c_lary
class75525483_c_lass
claws106020833_c_laws
clays105521333_c_lays
clears84116563_clears
coalas87418963coala_s
coalers94419353coalers
coilers93619903coilers
colas75436773_cola_s
collar83816173collar_
collard103712923collard
collards113310193collards
colors86622373_colors
coolers93522493coolers
copular113810613copular_
copulas113811573copula_s
corulers1039773corulers
costars94218013costars
cottars94412243cottars
cougar958783cougar_
coulees9315513coulees
coulis84018763coul_is
couloirs1045993couloirs
coulters103614313coulters
couplers123311323couplers
courlans10117613courlans
couters93827303couters
cubers105318353_cubers
culets85518513_culets
cullays12347703_cullays
cullers93418853_cullers
cullis84115993_cullis
culls75425813_cul_ls
culms95314193_cul_ms
cults75022553_cul_ts
cultus85110733_cultus
culvers12329833_culvers
curara83712203_curara
curaras93911953_curaras
curare84916953_curare
curares94916853_curares
curari84414403_curari
curaris94114773_curaris
curers84923193_curers
curlers94218073_curlers
currs75624393_cu_rrs
curs65645543_cu__rs
cutlas8313103_cutla_s
cutlass938013_cutlass
cutlers94217003_cutlers
cymars13599153_cymars
czars164812913_c_zars
dollars83311023dollars
doulas75114993doula_s
eclairs935963ec_lairs
eclats8313033ec_lats
escolars1045343escolars
facular122810453facular_
feuars938653feu_ars
focusers13134373focusers
foulard11257283foulard
foulards12266463foulards
fulmars1246423_fulmars
globulars1242453globulars
guars65021053_gu_ars
gulags837543_gulags
gular6314833_gular_
haulers104012443haulers
hulas84920883_hula_s
insulars8137323insulars
jocularly2173303jocularly
jugulars1643233jugulars
kulaks976113_kulaks
lacunars10114733lacunars
lars46956573___lars
lobular936673lobular_
loculate101011403loculate
locules92812603locul_es
loculus9296973locul_us
lunars65012813_lunars
macular113011953macular_
maculas113114023macula_s
malars85020683_malars
maulers94213303maulers
medlars10259443medlars
modular1087363modular_
molars85517323_molars
monoculars1444503monoculars
morular978223morular_
morulas959723morula_s
mylars114310443_mylars
nodular876703nodular_
oars46846033o___ars
ocas66729633oc__a_s
occulters1343453occulters
occults1135123occul_ts
occurs10136553oc_curs
oceans81211003oc_eans
ocellar936533ocellar_
ocellus935983ocellus
ocelots977233ocelots
ochers113915303oc_hers
ocicats11137413ocicats
ockers123813903oc_kers
octads987333oc_tads
octans81411143oc_tans
ocularists1284963ocularists
oculi72010793ocul__i
oculist9310883oculist
oculists1037133oculists
oglers74313183o_glers
oilers64721193o_ilers
ollas54218283o_lla_s
onlays9398713o_nlays
operculars1443683operculars
oracular1047543oracular_
oscula837293oscula__
osculant1046953osculant
osculate101010613osculate
osculates11109393osculates
oscules938123oscul_es
ostlers72911203ostlers
ottars64112223o_ttars
ourari63413543o_urari
ouraris73512933o_uraris
ours47237563o_u__rs
outers64230173o_uters
outlaws10249603outlaws
outlays102610903outlays
outwars10912793outwars
ovulate1039453ovulate
ovulates1148523ovulates
ovules938223ovul_es
peculiars1343453peculiars
pedlars103210213pedlars
pillars9313493pillars
polars84419353_polars
poplars113910333poplars
popular11319573popular_
poulard10299733poulard
poulards11288233poulards
pulers83820283_pulers
pulsars9358913_pulsars
regulars936253regulars
rulers64317093_rulers
scalar83612443scalar_
scalare93311843scalare
scalares103210983scalares
scalers93817263scalers
scapulars1343883scapulars
scars75433533sc__ars
scholars1336683scholars
scubas103710223scuba_s
sculkers14306933sculkers
sculks123610263scul_ks
scullers103510483scullers
sculls84613883scul_ls
sculps104611753scul_ps
sculpts11377063sculpts
secular92211543secular_
simulars1047073simulars
soucars938423soucars
sugars7312423_sugars
talars66021683_talars
titulars845863titulars
tolars64817943_tolars
torulas759853torula_s
ulans54921303__ulans
uvular955573uvular_
uvulas946523uvula_s
velars93913723_velars
vulgars11306533_vulgars
yulans958673_yulans
zonular1656493zonular_
zonulas1637023zonula_s

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.423422437.4
2DLD Change Limit1340272106.62320236.6
3Display Results2102100.0802625.0
 (SQL Overall)1786912107.12625075.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.