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

75 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
defrocks184411(None) 
defrock1744641defrock_
bedrocks1745332bedrocks
defocus1335282def_ocus
deforces14248402deforces
defrocked2043052defrocked
defrosts1244832defrosts
derricks1544432derricks
disfrocks1942972disfrocks
frocks154111212__frocks
unfrocks1753842unfrocks
bedrock1645643bedrock_
beflecks1943753beflecks
bemocks1735373be_mocks
brocks145214153__brocks
caprocks1835943caprocks
crocks145118423__crocks
daglocks1643993daglocks
deadlocks1743803deadlocks
decks124822193de___cks
decocts1237833de_cocts
decrowns14265063decrowns
defaces133213403def_aces
defects134511523def_ects
defences1439633defences
deflects14336733deflects
defoams1336193def_oams
defogs1156683def_o_gs
deforce13267243deforc_e
deforced15247373deforced
deforcer14246903deforcer
deforcers15265503deforcers
deforms1337803def_orms
defrags1236193defr_ags
defrauds1343243defrauds
defrays1436113defr_ays
defrocking2143153defrocking
defrost1139553defro_st
derrick1435803derrick_
deticks1437353de_ticks
detracts11138833detracts
diestocks1644383diestocks
disfrock1843303disfrock_
docks126022313d___ocks
dornocks1544093dornocks
drecks13459203d__recks
drouks1137123d__rouks
durocs9569703d_uroc_s
earlocks1435693_earlocks
elflocks1742743elflocks
fetlocks1744713fetlocks
flocks154713533__flocks
frock145314653__frock_
hemlocks1944993hemlocks
kebbocks1743023kebbocks
lavrocks1743663lavrocks
mudrocks1743993mudrocks
outrocks1437903outrocks
peacocks1844993peacocks
petcocks1844583petcocks
recocks154711463re_cocks
redocks14409933re_docks
refocus1236973ref_ocus
refracts13137383refracts
refronts1137773refronts
relocks134411293re_locks
reracks132310533re_racks
restocks1437503restocks
retracks14149103retracks
rimrocks1644043rimrocks
rocks114626413___rocks
seacocks1645643seacocks
trocks123614633__trocks
unfrock1674633unfrock_
wedlocks1844393wedlocks

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 Filter1786911461620.420425454.8
2DLD Change Limit146162756.51622431.2
3Display Results75750.0302500.0
 (SQL Overall)178691756.96625651.9
 
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.