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

144 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
coble9482317(None) 
cable95329911cable
cobble123615261cobble
cobles104622881cobles
cole66956111co_le
noble74420991noble
roble75223021roble
able66340532_able
amble95924642amble
bible95119422bible
bobble94115142bobble
bogle85821682bogle
bole66448692bo_le
boule74828042boule
cabled114819872cabled
cabler104519172cabler
cables104527552cables
cablet104429462cablet
carle74535702carle
chile105626892chile
chyle134913482chyle
coal66939252coal_
coala77521122coala
coaled95022702coaled
coaler84121712coaler
coals76129602coals
coaly105521592coaly
cob710258752cob__
cobalt10317392cobalt
cobb106422002cob_b
cobber124116842cobber
cobbled143411632cobbled
cobbler133311822cobbler
cobbles133814822cobbles
cobbs115013992cobbs
cobby145516412cobby
cobia94117512cobia
cobra95214402cobra
cobs87043142cob_s
cobweb1533242cobweb
cockle143913572cockle
codable12311662codable
coddle104713852coddle
code77347732co_de
coffle14359042coffle
coil66439652coil_
coiled95123932coiled
coiler84421592coiler
coils75030082coils
coke107038382co_ke
col59360352co_l_
cola66541392co_la
colby124415062colby
cold77338772co_ld
coled85540752co_led
coles76055062co_les
collet84030362collet
collie83621992collie
colly104926772colly
cols66553082co_ls
colt67158242co_lt
coly96940532co_ly
comae97128422comae
combe116223542combe
come87547702co_me
comte96125472comte
cone67256962co_ne
conge85227592conge
conte76633202conte
cooee74531022cooee
cool66940492cool_
cooled95224582cooled
cooler84824712cooler
coolie83821602coolie
cools75632632cools
cooly105525422cooly
cope86847382co_pe
copse95623922copse
corbel103715972corbel
corbie103618202corbie
core67263112co_re
corse75036182corse
cosie74728262cosie
cote66648732co_te
coude85022632coude
could86517712could
coulee8323502coulee
coupe96023482coupe
couple104415962couple
cove95837072co_ve
cowl97530812cowl_
cowled125218382cowled
cowls106922212cowls
coxae146115182coxae
coyly135614892coyly
cozie163519132cozie
cube85830212cub_e
cycle1239522cycle
doable93115242doable
dobie84920332dobie
dobla84913642dobla
dole56550002do_le
double94013992double
fable105824752fable
foible11410382foible
gable85325522gable
gobble113512982gobble
goblet93219482goblet
hobble133913432hobble
hole77553392ho_le
hoyle11314412hoyle
jole117233822jo_le
joule124918202joule
lobe65535362lob_e
lobule82910062lobule
mobile103613542mobile
mobled113213182mobled
mole66251832mo_le
nobble103814312nobble
nobler83713452nobler
nobles83319722nobles
nobly105314402nobly
obe56638642_ob_e
oboe66822942_oboe
obole75917142_obole
ogle56325052_ogle
ole37155212_o_le
orle45630462_orle
pole65951302po_le
robe65335642rob_e
robles85321692robles
role45851822ro_le
rouble83913312rouble
ruble74521252ruble
sable74732162sable
socle7419572socle
sole46053672so_le
table75429602table
toile54626492toile
tole46052902to_le
voile84719722voile
vole75236982vo_le
wobble133212312wobble
yodle94515042yodle

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 Limit538001441.82629463.3
3Display Results1441440.0334363.6
 (SQL Overall)1786911441.95291542.5
 
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.