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

61 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
unfrocks175384(None) 
unfrock1674631unfrock_
defrocks1844112defrocks
frocks154111212__frocks
unblocks1644522unblocks
uncocks1537232un_cocks
undocks1436162un_docks
unfrocked1944222unfrocked
unlocks1337062un_locks
untracks1437522untracks
bedrocks1745333bedrocks
brocks145214153__brocks
caprocks1835943caprocks
crocks145118423__crocks
defrock1744643defrock_
disfrocks1942973disfrocks
elflocks1742743elflocks
enforces13208013enforces
flocks154713533__flocks
frock145314653__frock_
gunlocks1544683gun_locks
gunstocks1643233gunstocks
infracts1346623infracts
knocks11397443kn__ocks
lavrocks1743663lavrocks
mudrocks1743993mudrocks
nocks115121013_n__ocks
outrocks1437903outrocks
rimrocks1644043rimrocks
rocks114626413___rocks
sunblocks1743413sunblocks
trocks123614633__trocks
unblock1545793unblock_
unbraces12229413unbraces
unbroke13217743unbro_ke
uncloaks1444133uncloaks
uncock1438563un_cock_
uncorks1337443un_corks
uncross938193uncro_ss
uncrowns1344363uncrowns
undock1337703un_dock_
unfences1337933unfences
unfolds11146803unf_olds
unforced14239133unforced
unfrees1048643unfr_ees
unfrocking2043533unfrocking
unfroze1945413unfro_ze
unfrozen2043753unfrozen
unhooks1436413un_hooks
unlock1248533un_lock_
unpacks1576093un_packs
unpicks1545183un_picks
unrobes9269733un_robes
unrolls797793un_rolls
unroofs1035783un_roofs
unroots738563un_roots
unstacks1446043unstacks
unsticks1436233unsticks
untacks1357503un_tacks
untrack1338703untrack_
untucks1334673un_tucks

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.406440125.6
2DLD Change Limit146162616.03024239.1
3Display Results61610.0331848.5
 (SQL Overall)178691616.46927622.7
 
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.