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

100 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
brocks14521415(None) 
blocks144513941blocks
bocks134526571b_ocks
bricks144614621bricks
brock136017071brock_
brooks125813881brooks
crocks145118421crocks
frocks154111211frocks
rocks114626411_rocks
trocks123614631trocks
backs135729622b_acks
becks135522012b_ecks
bedrocks1745332bedrocks
bemocks1735372bemocks
blacks144914952blacks
block134917842block_
blocky17388352blocky
blocs95219652bloc_s
bock126032512b_ock_
bonks116326462b_onks
books115729712b_ooks
borks115727702b_orks
bosks115218852b_osks
braces108427772braces
brachs134415752brachs
bracts105617772bracts
branks124817382branks
breaks124816422breaks
breeks125310792breeks
brick134618152brick_
bricky17489092bricky
brinks124616312brinks
brisks124611402brisks
broads94515142broads
broche133612102broche
brocket154013382brocket
brockets16328122brockets
broils84114172broils
broke116019782bro_ke
bromes104719762bromes
bromos104213312bromos
broncos11188072broncos
broncs101611152broncs
broods95416382broods
brook114717762brook_
brooms104915872brooms
broos75126412bro_os
bros65635662bro__s
broses86524402broses
broths115013922broths
browns116415632browns
brows105425982bro_ws
bucks134824292b_ucks
burdocks1744032burdocks
chocks174815312chocks
clocks144916232clocks
cocks135227162_cocks
cracks144817002cracks
cricks144316052cricks
croaks125812982croaks
crock135921992crock_
crocs95722432croc_s
crocus104813172crocus
crooks124914412crooks
crucks144412582crucks
docks126022312_docks
drecks13459202drecks
drouks1137122drouks
flocks154713532flocks
frock145314652frock_
groks105716122gro_ks
hocks144925492_hocks
jocks185118082_jocks
knocks11397442knocks
locks115126922_locks
mocks135023822_mocks
nocks115121012_nocks
pocks135022962_pocks
pricks144414262pricks
racks115028852_racks
recks115625132_recks
ricks115126132_ricks
rock105735182_rock_
rocky144513852_rocky
rocs65533662_roc_s
rooks95325042_rooks
rucks114422052_rucks
shocks154414572shocks
smocks145710012smocks
socks114926082_socks
stocks124715632stocks
tracks124818842tracks
tricks125319012tricks
troaks104410592troaks
trock114817602trock_
trucks124711972trucks
wracks154711112wracks
wrecks15418882wrecks
wricks154610622wricks
yocks144418372_yocks

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825511003.39324329.8
3Display Results1001000.0303333.3
 (SQL Overall)1786911003.53350577.7
 
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.