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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
brokered153608(None) 
bickered17108002bickered
bordered1248932bordered
bowered133113042b_owered
broidered1344932broidered
broker124314242broker__
brokers133111912broker_s
brothered1546002brothered
bunkered15177182bunkered
rogered939552_rogered
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
beavered1437503beavered
betokened1643403betokened
bettered113011833bettered
bickerer16106773bickerer
bistered112913323bistered
bittered112711833bittered
blazered2035063blazered
blinkered1644413blinkered
bloodred1234083bloodred
bogeyed1435673b_ogeyed
boogeyed1543723boogeyed
booked135319503book__ed
bookend14396643booke_nd
booker124719193booker__
bookers134016613booker_s
borderer1168103borderer
bored85034303b_o__red
borked135117293bork__ed
bothered142110393bothered
boweled132810693b_oweled
bracketed1855863bracketed
braked135318693brak__ed
brakemen1644843brakemen
brazened20134903brazened
breed85526693br__e_ed
breezed19287053br_eezed
breveted1435623breveted
brewed125411873br__ewed
briefed1335743br_iefed
broached16309123broached
broadened1364333broadened
brocaded1436353brocaded
broiderer1244353broiderer
broiled103811423bro_iled
brokage1436673brokage_
brokages1536253brokages
broke116019783brok__e_
broken124011523brok__en
brokenly1744203brokenly
brokerage1643313brokerage
brokerages1743363brokerages
brokering1636283brokering
bromated1339173bromated
bromized22215893bromized
bronzed19308213bro_nzed
brooded113510933bro_oded
brooked143610033bro_oked
broomed124111053bro_omed
browed125216393bro__wed
browned134710973bro_wned
browsed134511233bro_wsed
bucketed1736763bucketed
bucklered1844543bucklered
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
buttered112712623buttered
cankered153010223cankered
clovered14187363clovered
cockered17710213cockered
cohered133514693_cohered
coopered133310933coopered
cornered11311133cornered
covered133315293_covered
cowered133214643_cowered
cratered1149673cratered
crocketed1845123crocketed
dackered16116893dackered
daikered1495223daikered
dickered16117533dickered
dormered1255673dormered
dowered122811553_dowered
flowered1546013flowered
frogeyed1642783frogeyed
glowered1345753glowered
grokked1233673grok_ked
groveled13345453groveled
hankered16289443hankered
homered133212713_homered
hoovered15195413hoovered
hovered143411573_hovered
hunkered16186923hunkered
lackered15108673lackered
lowered112711913_lowered
nickered15117023nickered
ordered9108533or_dered
overed102216623__overed
portered112311533portered
powered132911643_powered
proceed12310543proce_ed
procured1336603procured
proffered1843433proffered
properer1259203properer
prospered1446963prospered
proverbed1743813proverbed
puckered1736103puckered
rekeyed1536163_rekeyed
revered112819333_revered
roared75015393_ro_ared
rocketed15157793_rocketed
rodeoed937883_rodeoed
roweled11269863_roweled
showered1537013showered
snookered1443263snookered
sobered102912433_sobered
suckered1537833suckered
tinkered1387683tinkered
tokened1236393_tokened
towered112911403_towered
troked114114583trok__ed
troweled12106113troweled
tuckered1535963tuckered

Search took 9 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.1731032896.0
2DLD Change Limit1461621288.43617326.0
3Display Results1281280.0632031.7
 (SQL Overall)1786911288.67220605.5
 
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.