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

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
codas8472424(None) 
cocas95926571cocas
coda77029341coda_
codes86247291codes
cods76848101cod_s
colas75436771colas
comas95833001comas
odas57230261_odas
sodas64123541sodas
boas66150832bo_as
bodes84935102bodes
bods76244712bod_s
bolas74733762bolas
boras75938302boras
botas75328782botas
cacas95627982cacas
cades85440732cades
cadis84428502cadis
cads76144522cad_s
camas96333522camas
casas75327842casas
cedar84014322cedar
cedars93312832cedars
cedes84927332cedes
cedis84317082cedis
chads116122232chads
chias104625522chias
cholas114818002cholas
clads85722732clads
clods85320862clod_s
coal66939252co_al
coalas87418962coalas
coals76129602coals
coast75236272co_ast
coat67558352co_at
coats75635002coats
coax136922982co_ax
cobbs115013992cobbs
cobias104014992cobias
cobras104014192cobras
cobs87043142co_bs
coca88030642coca_
cocks135227162cocks
cocoas104915742cocoas
cocos95624692cocos
cod69660122cod__
code77347732cod_e
codec107120342codec
codecs115112932codecs
coded95433182coded
codeias103911222codeias
coden86128542coden
codens94821012codens
coder86134222coder
coders95426982coders
codex155817582codex
codon86522852codon
codons96119462codons
coeds85920162coeds
coffs134916302coffs
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
cokes115537192cokes
cola66541392cola_
colds85726972colds
coles76055062coles
cols66553082co_ls
colts76633292colts
colzas174010512colzas
coma87134852coma_
comae97128422comae
comal95125132comal
combs116122962combs
comes97246992comes
commas124814572commas
compas125817062compas
comps115526052comps
condos94322332condos
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
cuds76730472cud_s
cycas126513822cycas
cymas126417882cymas
dadas75819862dadas
dodos75819392dodos
donas65926472donas
dopas85019062dopas
goads77022852goads
goas55239942go_as
gods65438042god_s
hodad10311352hodad
hodads1147962hodads
hods87239862hod_s
hondas10313352hondas
horas86333102horas
hoyas115016162hoyas
iotas54821112iotas
jotas125717442jotas
judas134911882judas
koas85635092ko_as
kolas94822232kolas
koras95927112koras
loads65323372loads
lodes66436912lodes
lotas55926302lotas
moas65545342mo_as
modal85919242modal
modals93914452modals
modes85537412modes
mods77945052mod_s
modus85417202modus
molas75132092molas
monas74732152monas
moras76438782moras
moxas145014392moxas
nadas66320812nadas
nodal64717792nodal
nodes64633492nodes
nods55838222nod_s
nodus66315992nodus
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
ocas66729632_ocas
oda48133042_oda_
odah87018932_odah
odahs95610082_odahs
odds68919922_odds
odes57243242_odes
ods47546212_od_s
okas85225392_okas
pods76540152pod_s
roads66523622roads
rodes614039082rodes
rods56442062rod_s
rotas54827722rotas
sobas74424252sobas
socas74026182socas
soda56329382soda_
sods54940212sod_s
sofas85320712sofas
sojas124716392sojas
somas76030372somas
soras55041012soras
soyas84520912soyas
toads65621072toads
today96416952today
todays10458102todays
tods56141842tod_s
toeas55726422toeas
togas67823002togas
tolas54532772tolas
toras55540372toras
vodkas1443542vodkas
woads94818442woads
yodhs12669012yodhs
yods86531182yod_s
yogas96615602yogas
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.310576422.6
2DLD Change Limit538002101.44037361.1
3Display Results2102100.0603500.0
 (SQL Overall)1786912101.81098724.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.