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

140 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
bonneted113622(None) 
sonneted936181sonneted
bannered11299322bannered
bonnet85524632bonnet__
bonnets94812802bonnet_s
connected1438752connected
connoted1138862connoted
donnered10307752donnered
sonnetted1044542sonnetted
unbonneted1343142unbonneted
annexed1535753_annexed
banned94721343bann__ed
banneret102412473banneret
bannet84925333bannet__
bannets94013843bannet_s
banqueted2143543banqueted
bantered113313633bantered
basseted1136753basseted
bayoneted1542773bayoneted
bennet84823363bennet__
bennets94712163bennet_s
billeted1137643billeted
binned94414543binn__ed
blanketed1643913blanketed
blunted104210663blun_ted
boasted104113743bo_asted
boated94221973bo__ated
bogarted1235053bogarted
bogeyed1435673bo_geyed
boinked14457043boin_ked
bolete8519613bo_lete_
boletes9316063bo_letes
bolted94617803bo__lted
bonded104719953bo_n_ded
boned85133243bo_n__ed
bonehead1445933bo_nehead
boneset9316433bo_neset
boneyer1237403bo_neyer
bonged105719603bo_n_ged
bonked135517313bo_n_ked
bonne75124713bonn__e_
bonnes85621453bonn__es
bonneting1236173bonneting
bonnie85314853bonn_ie_
bonnier94711313bonn_ier
boogeyed1543723boogeyed
boosted104111983bo_osted
booted94822733bo__oted
borated104116363bo_rated
bordered1248933bordered
bornite9311183bornite_
bornites10310983bornites
bothered142110393bothered
bounced123610553boun_ced
bounded113613763boun_ded
bountied1136333bountied
boweled132810693bo_weled
bowered133113043bo_wered
breveted1435623breveted
bucketed1736763bucketed
budgeted1344883budgeted
buffeted1753733buffeted
bulleted1138393bulleted
bunkered15177183bunkered
bunted95219183b_un_ted
coannexed1942953coannexed
colleted113011663colleted
competed154113593competed
conceded1438293conceded
conceited14310423conceited
concerted14312113concerted
concreted1439413concreted
confected1739073confected
confuted1437683confuted
congeed113212313conge_ed
congested1338673congested
connate9315753connate_
connecter1349053connecter
conned95119703conn__ed
connived1436433connived
connote9311613connote_
connotes10311453connotes
consented12311943consented
contented12313043contented
contested12310693contested
convected1738783convected
convened143412223convened
convented15410753convented
converted15311563converted
conveyed17247923conveyed
cornered11311133cornered
cornuted1137473cornuted
coroneted12278323coroneted
corseted11311473corseted
cosseted1178343cosseted
counted103815803coun_ted
coveted133011523co_veted
docketed16156583docketed
donated93513863do_nated
donned85015743donn__ed
donnee74317063donne_e_
donnees84210363donne_es
donnerd9427813donne_rd
fomented1437803fomented
funneled1254873funneled
gorgeted1135353gorgeted
honeyed1437773ho_neyed
jointed15378503join_ted
jonesed1536263jo_nesed
junketed2033523junketed
kenneled1334003kenneled
lanceted1137073lanceted
mannered11249653mannered
moneyed1337493mo_neyed
mongered1238953mongered
monkeyed1844153monkeyed
mounted103611533moun_ted
nonrated9310843nonrated
nonvested1346003nonvested
pennated11299543pennated
pinnated11338553pinnated
pocketed17147143pocketed
pointed103813983poin_ted
pondered126411293pondered
rocketed15157793rocketed
roqueted1834653roqueted
signeted1035973signeted
socketed15177343socketed
sonnet65923503sonnet__
sonneteer943063sonneteer
sonnetized2044473sonnetized
sonnets74211993sonnet_s
telneted935073telneted
toileted936993toileted
tunneled955233tunneled
unnoted8311363_unnoted
wondered13239943wondered
wonned104012063wonn__ed
wonted103213283wo_n_ted
zonated173310533zo_nated

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621407.15620425.1
3Display Results1401400.0602333.3
 (SQL Overall)1786911407.63923391.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.