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

155 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
cakey14551727(None) 
cagey115917821cagey
cake105439961cake_
caked126128621caked
cakes116037671cakes
caky136222441cak_y
fakey155515421fakey
ackee115825362ackee
akee85936812_akee
bake105637512bake_
baked126130772baked
baker115629542baker
bakery155911002bakery
bakes117035372bakes
cabby145314552cabby
caber95126832caber
caddy125414022caddy
cade76443912cade_
cades85440732cades
cadet85339332cadet
cadgy125210782cadgy
cafe95230322cafe_
cafes106426922cafes
cage75339062cage_
caged95426362caged
cager85229222cager
cages85936012cages
cagy106321992ca_gy
cakier123115242cakier
calked134617402calked
calker124917082calker
came87648752came_
camel96822802camel
cameo95924992cameo
cames97047312cames
campy145116182campy
candy115119822candy
cane66653112cane_
caned85838092caned
caner75334772caner
canes75350372canes
canker124422522canker
canny105817692canny
canty105226802canty
cape87242782cape_
caped104931802caped
caper94831622caper
capes95441922capes
care66968372care_
cared86050092cared
carer74942332carer
cares77369182cares
caret75360562caret
carex144822292carex
carked134024822carked
carney115315702carney
carny105822922carny
carry105823782carry
case65848082case_
cased86032412cased
casefy1436272casefy
cases75048382cases
casked134815512casked
casket124820992casket
casky144512682casky
cate66254592cate_
cater74840702cater
cates75951872cates
catty104520412catty
causey113513272causey
cave95941262cave_
caved116227562caved
caver105629062caver
caves105639702caves
cavy125920002ca_vy
cawed116627062cawed
cay87155982ca__y
chokey184811712chokey
clayey14407662clayey
coke107038382coke_
coked124730692coked
cokes115537192cokes
coky137526822cok_y
coney105932882coney
cooey105828222cooey
cookey155414332cookey
cosey106226712cosey
covey136121782covey
cozey196718542cozey
crake114823522crake_
crakes124921812crakes
crikey15317782crikey
cuke105824982cuke_
cukes115422092cukes
cutey105819792cutey
darkey145212422darkey
dikey135116422dikey
dykey16608672dykey
fake115534942fake_
faked135225482faked
faker124824592faker
fakery16509262fakery
fakes126032482fakes
flakey164410512flakey
gamey115320552gamey
hake115637842hake_
hakes126034302hakes
hawkey19507632hawkey
hayey144812532hayey
hokey155422182hokey
jake155925772jake_
jakes165023642jakes
jokey195014692jokey
key105833332__key
lacey105820912lacey
lackey154813352lackey
lake85741602lake_
laked105731122laked
laker95432872laker
lakes95737652lakes
laky116725822lak_y
make105537882make_
maker114127812maker
makes115336852makes
mamey125418832mamey
matey107022662matey
naked105320852naked
oaken95814382oaken
oaky116419952oak_y
pacey126720282pacey
pokey145318972pokey
rake84841572rake_
raked105831422raked
rakee96031172rakee
raker94529792raker
rakes94440352rakes
rekey124014732rekey
sake85244962sake_
saker95132022saker
sakes95540752sakes
scarey115016982scarey
snakey135011272snakey
tackey154613082tackey
take84739262take_
taken94819142taken
taker95229002taker
takes94437792takes
wake114935702wake_
waked135626752waked
waken124818472waken
waker125526592waker
wakes126633652wakes
waney115120322waney
wavey145115542wavey
yawey14458272yawey

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 Limit538001551.82629463.3
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.96590936.9
 
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.