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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
clown10521473(None) 
blown105716671blown
clon66232481clo_n
clowns114810111clowns
crown105620081crown
flown116213991flown
lown76929291_lown
adown95611662adown
aloin55227422aloin
alow75328592alow_
beclown1435422beclown
blawn106813702blawn
blow95827192blow_
blows105423832blows
blowy134315322blowy
brown105619532brown
chon96627792cho_n
chow125820992chow_
chows135618202chows
cion613330912cio_n
clan65633922cl_an
claw95624342claw_
claws106020832claws
clean75420412clean
clew95520572clew_
clews105516332clews
cloak115214012cloak
clock134917982clock
clod76124612clo_d
clods85320862clods
clog76123242clo_g
clogs85519552clogs
clomb115714702clomb
clomp115615702clomp
clone75728162clone
clonk114417442clonk
clons75228132clons
cloot76127052cloot
clop86929892clo_p
clops95924852clops
close76425222close
clot66542422clo_t
cloth105817542cloth
clots75627642clots
cloud86716422cloud
clour76617282clour
clout75330462clout
clove105619442clove
cloven114211512cloven
clowned13447732clowned
cloy96623832clo_y
cloys104916942cloys
cloze165517542cloze
coin66645352c_oin
colin76231692colin
colon78630192colon
con510268022c_o_n
conn66229132c_onn
coon67248942c_oon
corn69945812c_orn
cow89856712c_ow_
cowl97530812c_owl
cows97046642c_ows
cowy126427362c_owy
croon75522782croon
crow96428132crow_
crowd115815622crowd
crowns115615112crowns
crows105727312crows
down86427492_down
drown95515822drown
eloin55923202eloin
flow105924922flow_
flows115822362flows
frown115415972frown
glow85222522glow_
glows95518032glows
gown85724072_gown
grown95317352grown
known12568342known
lawn75925632_lawn
loan47436452_loan
loin46838722_loin
loon47344792_loon
lorn46435252_lorn
low66051872_low_
lowe75435312_lowe
lows75843012_lows
mown95424442_mown
own66429702__own
plow95923232plow_
plows105419902plows
shown115216482shown
slow77729492slow_
slows85323462slows
sown75127452_sown
town76928702_town

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.313570897.8
2DLD Change Limit53800971.39038705.0
3Display Results97970.0332939.4
 (SQL Overall)178691971.736102932.6
 
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.