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

202 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
cobwebs163193(None) 
cobweb1533241cobweb_
cobbers134114752cobbers
cobbs115013992cob__bs
cobles104622882coble_s
cobwebby196582cobwebby
cowers114625532co_wers
cubebs12508682cub_ebs
blebs96416153__blebs
bobbers103614283bobbers
bowels114315593bo_wels
bowers115523703bo_wers
cabers105023923cab_ers
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
cabobs124311893cab_obs
celebs1037883c_elebs
chawers154412053chawers
chewers154111143chewers
clawers123910973clawers
clobbers14397513clobbers
coalers94419353coalers
coatees93816553coatees
coaters93525793coaters
coaxers164311083coaxers
coaxes154715633coaxe_s
cobalts1139203cobalts
cobb106422003cob__b_
cobber124116843cobbe_r
cobblers14359593cobblers
cobbles133814823cobbles
cobby145516413cob__by
cobias104014993cob_ias
coble94823173coble__
cobnuts1135353cobnuts
cobras104014193cob_ras
cobs87043143co___bs
cobwebbed184903cobwebbed
cockers153618333cockers
codders114114453codders
codecs115112933co_decs
codens94821013co_dens
coders95426983co_ders
codes86247293co_de_s
codgers115113933codgers
coeds85920163co__eds
coffees15329573coffees
coffers154112693coffers
cogways1634633cogways
coilers93619903coilers
coiners93620753coiners
cokes115537193co_ke_s
coles76055063co_le_s
coleus86818273co_leus
colies84837053colie_s
collets93517903collets
colters93522443colters
combers134516623combers
combes125321733combe_s
combs116122963co__mbs
comers105328083co_mers
comes97246993co_me_s
comets105823583co_mets
compels133210883compels
comtes106222813comte_s
cones76457423co_ne_s
coneys115218423co_neys
confabs1435393confabs
confers124120093confers
confess12399903confess
congees103517923congees
congers104223233congers
conges94928173conge_s
conies84338593conie_s
conkers133721043conkers
conners94023113conners
contes84432913conte_s
conveys15308223conveys
cooees85621893co_oees
cooers84324563co_oers
cooeys114914483co_oeys
cookers134619463cookers
cookeys16478503cookeys
coolers93522493coolers
coombes133810663coombes
coombs124210193co_ombs
coopers114019483coopers
cooters94525723cooters
copens106119963co_pens
copers104629843co_pers
copes97747103co_pe_s
copiers114215963copiers
copies104130303copie_s
coppers133519753coppers
copses104922473copse_s
copters113621283copters
coquets18399893coquets
corbels113813593corbels
corbies113520123corbie_s
corders104520883corders
corers85231073co_rers
cores76361853co_re_s
corkers134118853corkers
cormels113813373cormels
corneas94717003corneas
cornels94716663cornels
corners94723313corners
cornets94820573cornets
corses84433463corse_s
corsets94819803corsets
corvees124613793corvees
corves115122523corve_s
corvets124715023corvets
corymbs1633453corymbs
cosecs105015213co_secs
coses76949493co_se_s
cosets85824403co_sets
coseys115215813co_seys
coshers123618183coshers
coshes115022783coshe_s
cosies84932153cosie_s
cossets95014283cossets
costers94128333costers
cotes76347843co_te_s
cotters94323443cotters
coulees9315513coulees
coupes105022523coupe_s
couters93827303couters
covens114919263co_vens
covers114627963co_vers
coves105539173co_ve_s
covets114819643co_vets
coveys145413503co_veys
cowbell1445223cowbell
cowbells1544993cowbells
cowboys1735253cowboys
cowed115637853co_we_d
cower104531773co_we_r
cowherbs1833543cowherbs
cowls106922213co_w_ls
cowpeas1437273cowpeas
cows97046643co_w__s
coxes145430863co_xe_s
coxless1637743coxless
coyness1277323coyness
cozens176314923co_zens
cozes166033243co_ze_s
cozeys204610913co_zeys
cozies174521413cozie_s
cozzes164510893cozze_s
crewels12438493crewels
crowers124614903crowers
cubeb115814663cub_eb_
cubers105318353cub_ers
cubes95028163cub_e_s
dobbers123513253dobbers
dobies94422093dobie_s
dowels104813343do_wels
dowers104523293do_wers
gobbets12327643gobbets
gobies95418063gobie_s
goblets103210183goblets
goboes95914443goboe_s
hobbers143512343hobbers
hobnobs1443603hobnobs
hoboes114717443hoboe_s
howes114730263ho_we_s
jobbers182911133jobbers
jobless16237563jobless
lobbers113713943lobbers
lobes75331003lob_e_s
lowers94624923lo_wers
lowes85732463lo_we_s
mobbers133610923mobbers
mowers113219403mo_wers
nobles83319723noble_s
obes66036833_ob_e_s
obeys107010643_ob_eys
objets15125323_objets
oboes75717713_oboe_s
obsess845943_obsess
owes75137103_o_we_s
powers113822323po_wers
robbers112814163robbers
robes75133303rob_e_s
robles85321693roble_s
rowels94515453ro_wels
rowens94515303ro_wens
rowers94924573ro_wers
sobbers114114263sobbers
sobers85218863sob_ers
sowens93613153so_wens
sowers94923443so_wers
subdebs1236483subdebs
tobies84521023tobie_s
towels94314643to_wels
towers94423673to_wers
vowels124410483vo_wels
vowers124317183vo_wers
webs96622123___webs
yowes114926373yo_we_s

Search took 7 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.406440125.6
2DLD Change Limit1340272026.20021617.3
3Display Results2022020.0802525.0
 (SQL Overall)1786912026.68626726.1
 
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.