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

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

84 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
crocketed184512(None) 
cricketed1854681cricketed
crocheted1745311crocheted
rocketed15157791_rocketed
bracketed1855862bracketed
cockered17710212c_ockered
cockeyed2096122c_ockeyed
cricketer1744562cricketer
crocheter1645562crocheter
crocked164014432crock__ed
crocket154615672crocket__
crockets16339542crocket_s
croqueted2143312croqueted
docketed16156582_docketed
pocketed17147142_pocketed
racketed15169122_racketed
rocketer14158332_rocketer
socketed15177342_socketed
brocket154013383brocket__
brockets16328123brocket_s
brokered1536083bro_kered
bucketed1736763_bucketed
cacheted16148233c_acheted
casketed1534953c_asketed
checkered2144683checkered
chickened2144623chickened
chocked194411613chock__ed
clocked164112833clock__ed
closeted1135613clo_seted
cockaded1836393c_ockaded
cocked155022563c_ock__ed
cockerel16107113c_ockerel
cockeye1867223c_ockeye_
cockeyes1967033c_ockeyes
cockled163710823c_ock_led
cocreated142710093c_ocreated
colleted113011663c_olleted
competed154113593c_ompeted
concreted1439413concreted
coroneted12278323coroneted
corseted11311473c_orseted
cosseted1178343c_osseted
coveted133011523c_o_veted
cracked163514743crack__ed
crackled17428863crack_led
cricetid1345193cric_etid
cricked164814283crick__ed
cricket154716953cricket__
cricketers1843893cricketers
crickets16418123cricket_s
croaked143710533croak__ed
crochet143616663crochet__
crocheters1744503crocheters
crochets15359833crochet_s
crockeries1857113crockeries
crockery19356603crocke_ry
crocoite1248053crocoite_
crocoites1347463crocoites
crooked143910943crook__ed
crookeder1642823crookeder
frocked17439333frock__ed
grommeted1553163grommeted
jacketed22146533_jacketed
jockeyed2563413_jockeyed
packeted17148283_packeted
picketed17167383_picketed
pocketer16157373_pocketer
proceed12310553proc_e_ed
proceeded1544103proceeded
procreated1546443procreated
racheted14149503_racheted
rocked135022323_rock__ed
rocket125425283_rocket__
rocketeer15174493_rocketeer
rocketers15186883_rocketers
rocketry1744503_rocketry
rockets134615363_rocket_s
rockweed1843313_rockweed
roqueted1834653_roqueted
skyrocketed205763skyrocketed
thicketed1943613thicketed
ticketed15146643_ticketed
trinketed1444253trinketed
trocked144312243trock__ed

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641846.93621430.4
3Display Results84840.0332545.5
 (SQL Overall)178691847.39224173.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.