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 “cocas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

206 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
cocas9592657(None) 
cacas95627981cacas
coca88030641coca_
cocks135227161cocks
cocoas104915741cocoas
cocos95624691cocos
codas84724241codas
colas75436771colas
comas95833001comas
cycas126513821cycas
ocas66729631_ocas
socas74026181socas
boas66150832bo_as
bocks134526572bocks
bolas74733762bolas
boras75938302boras
botas75328782botas
caca85528082caca_
cacao95420002cacao
cacaos104616182cacaos
camas96333522camas
casas75327842casas
ceca84820782ceca_
cecal94619112cecal
chias104625512chias
chicas135916462chicas
chocks174815312chocks
cholas114817992cholas
cloacas1136232cloacas
clocks144916232clocks
coach125919452coach
coact96130572coact
coacts105314322coacts
coal66939252co_al
coalas87418962coalas
coals76129602coals
coast75236262co_ast
coat67558342co_at
coats75634992coats
coax136922972co_ax
cobbs115013982cobbs
cobias104014972cobias
cobras104014192cobras
cobs87043142co_bs
cocain101315012cocain
cocains111313922cocains
coccal9310222coccal
cocci82812672cocci
coccus979282coccus
cock126332902coc_k
cocky164215932cocky
coco87330602coc_o
cocoa98517882cocoa
coda77029342coda_
codes86247292codes
cods76848102co_ds
coeds85920162coeds
coffs134916302coffs
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
cokes115537192cokes
cola66541392cola_
colds85726972colds
coles76055062coles
cols66553082co_ls
colts76633292colts
colzas174010502colzas
coma87134852coma_
comae97128422comae
comal95125132comal
combs116122962combs
comes97246992comes
commas124814572commas
compas125817062compas
comps115526052comps
conchas144013312conchas
conchs134714902conchs
cones76457422cones
congas94417032congas
conks115525702conks
conns75024232conns
cons66057692co_ns
conus76726532conus
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
copal95621782copal
copals105018942copals
copay126516312copay
copays134911272copays
copes97747102copes
copras103517152copras
cops86751372co_ps
coral76033452coral
corals85325142corals
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
cos510270392co__s
coses76949492coses
coss66143492co_ss
costs77231142costs
cotan71521782cotan
cotans81317922cotans
cotes76347842cotes
cots68054842co_ts
cottas84615572cottas
coups95522472coups
coves105539172coves
cowls106922212cowls
cows97046642co_ws
coxa136922962coxa_
coxae146115182coxae
coxal146116672coxal
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
crocks145118422crocks
crocs95722432croc_s
crocus104813172crocus
cycad13507272cycad
cycads14476212cycads
cymas126417882cymas
docks126022312docks
docs75631152doc_s
donas65926472donas
dopas85019062dopas
focal104917672focal
focus105815882focus
goas55239942go_as
hocks144925492hocks
hocus104715202hocus
horas86333092horas
hoyas115016162hoyas
iotas54821112iotas
jocks185118082jocks
jotas125717442jotas
koas85635092ko_as
kolas94822232kolas
koras95927112koras
loca65527682loca_
local74820272local
locals83714502locals
lochs106715512lochs
locks115126922locks
locos75822602locos
locus74819992locus
lotas55926302lotas
micas96823052micas
moas65545342mo_as
mochas13310652mochas
mocks135023822mocks
mocs85834902moc_s
molas75132092molas
monas74732152monas
moras76438762moras
moxas145014392moxas
nocks115121012nocks
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
oca56731732_oca_
odas57230262_odas
okas85225392_okas
orcas75918622orcas
pacas96029402pacas
picas94626522picas
pocks135022962pocks
rocks114626412rocks
rocs65533662roc_s
rotas54827722rotas
sobas74424252sobas
soca66330052soca_
socks114926082socks
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
somas76030372somas
soras55041012soras
soyas84520912soyas
toeas55726422toeas
togas67823002togas
tolas54532772tolas
toras55540372toras
vocab12409972vocab
vocabs13336312vocabs
vocal104715642vocal
vocals113811582vocals
voces105918052voces
yocks144418372yocks
yogas96615602yogas
yucas106013912yucas
zoeas145815612zoeas

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002061.61033416.1
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.749102167.5
 
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.