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

316 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
colas7543677(None) 
bolas74733761bolas
cholas114817991cholas
coalas87418961coalas
coals76129601coals
cocas95926571cocas
codas84724241codas
cola66541391cola_
colds85726971colds
coles76055061coles
cols66553081col_s
colts76633291colts
colzas174010501colzas
comas95833001comas
kolas94822231kolas
molas75132091molas
tolas54532771tolas
alas46358122_alas
anlas55626932anlas
atlas55821582atlas
balas76937212balas
boas66150832bo_as
bola66035562bola_
bolar75123472bolar
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
boras75938302boras
botas75328782botas
boylas113011722boylas
cacas95627982cacas
calash11312432calash
calfs104919382calfs
calks115421602calks
callas84526752callas
calls75634732calls
calms95222352calms
calos74431902calos
camas96333522camas
canolas9313992canolas
casas75327842casas
cells75428062cells
cels65534972cel_s
celts75325782celts
chelas113817202chelas
chias104625512chias
chola104718032chola_
chollas123811352chollas
cholos114716852cholos
citolas939342citolas
clad76225822c_lad
clads85722732c_lads
clag75924572c_lag
clags85621122c_lags
clam86332292c_lam
clams95127672c_lams
clan65633922c_lan
clans75031012c_lans
clap86429042c_lap
claps95626182c_laps
clash106219032c_lash
clasp95517192c_lasp
class75525482c_lass
clast76030582c_last
claw95624342c_law
claws106020832c_laws
clay95927412c_lay
clays105521332c_lays
cloak115214012cloak
cloaks124411262cloaks
clods85320862clods
clogs85519552clogs
clons75228132clons
clops95924852clops
clots75627642clots
cloys104916942cloys
coal66939252co_al
coala77521122coala
coaly105521592coaly
coast75236262co_ast
coat67558342co_at
coats75634992coats
coax136922972co_ax
cobbs115013992cobbs
cobias104014982cobias
cobles104622882cobles
cobras104014192cobras
cobs87043142co_bs
coca88030642coca_
cocks135227162cocks
cocoas104915742cocoas
cocos95624692cocos
coda77029342coda_
codes86247292codes
cods76848102co_ds
coeds85920162coeds
coffs134916302coffs
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
cokes115537192cokes
col59360352col__
colby124415062colby
colbys13407152colbys
cold77338772col_d
cole66956112col_e
colead94114642colead
coleads102911422coleads
coled85540752coled
coleus86818272coleus
colic95726172colic
colics104219902colics
colies84837052colies
colin76231692colin
colins85229042colins
collar83816172collar
collars93816572collars
colly104926772colly
colog86619932colog
cologs96517352cologs
colon78630192colon
colons86028682colons
color76123742color
colors86622372colors
colt67158242col_t
coly96940532col_y
colza165112982colza
coma87134852coma_
comae97128422comae
comal95125132comal
combs116122962combs
comes97246992comes
commas124814572commas
compas125817062compas
comps115526052comps
cones76457422cones
congas94417032congas
conks115525702conks
conns75024232conns
cons66057692co_ns
conus76726532conus
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
copal95621782copal
copals105018942copals
copay126516312copay
copays134911272copays
copes97747102copes
copras103517152copras
cops86751372co_ps
copulas113811562copulas
coral76033452coral
corals85325142corals
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
cos510270392co__s
coses76949492coses
coss66143492co_ss
costs77231142costs
cotan71521782cotan
cotans81317922cotans
cotes76347842cotes
cots68054842co_ts
cottas84615572cottas
coulis84018752coulis
coups95522472coups
coves105539172coves
cowls106922212cowls
cows97046642co_ws
coxa136922962coxa_
coxae146115182coxae
coxal146116672coxal
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
culls75425812culls
culms95314192culms
cults75022552cults
cupolas11277752cupolas
cutlas8313092cutlas
cycas126513822cycas
cymas126417882cymas
doblas93812292doblas
doles67843752doles
dolls66126922dolls
dolmas95213042dolmas
dols56943052dol_s
dolts65626312dolts
donas65926472donas
dopas85019062dopas
doulas75114992doulas
foals85721692foals
folds95221692folds
folks126017122folks
galas65731642galas
goals65521292goals
goas55239942go_as
golds75421312golds
golfs95616102golfs
holds94623242holds
holes84748652holes
holks124720562holks
hollas94616902hollas
holms105117802holms
hols76946292hol_s
holts85627912holts
horas86333092horas
hoyas115016162hoyas
hulas84920882hulas
hylas114815902hylas
iotas54821112iotas
joles125230832joles
jolts125018882jolts
jotas125717442jotas
koalas104011662koalas
koas85635092ko_as
kola85124962kola_
kolos94921212kolos
koras95927112koras
las37281472__las
lolls512121732lolls
lotas55926302lotas
moas65545342mo_as
mola66035632mola_
molal75120342molal
molar75223092molar
molars85517322molars
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monas74732152monas
moolas83615592moolas
moras76438762moras
moxas145014392moxas
nalas55528362nalas
nolos54423352nolos
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
ocas66729632_ocas
odas57230262_odas
okas85225392_okas
olds55926572_olds
oles46453472_oles
ollas54218282ollas
polar75623452polar
polars84419352polars
poles75351002poles
polis74731162polis
polkas1239102polkas
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rotas54827722rotas
scolds95011232scolds
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
sola45541862sola_
solan55328152solan
solans64122492solans
solar55927342solar
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
somas76030372somas
soras55041012soras
soyas84520912soyas
talas55935892talas
toeas55726422toeas
togas67823002togas
tola45236332tola_
tolan55124012tolan
tolans64319272tolans
tolar55524112tolar
tolars64817922tolars
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toras55540372toras
violas93713522violas
volar86917412volar
voles86234042voles
volts85421292volts
volvas12447992volvas
wolds95420182wolds
wolfs116214162wolfs
yogas96615602yogas
yolks125412772yolks
zoeas145815612zoeas

Search took 3 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.1101624463.6
2DLD Change Limit538003161.93627789.3
3Display Results3163160.0933397.8
 (SQL Overall)1786913162.13983539.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.