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

172 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
asserted95790(None) 
assented957511assented
asserter877571asserter
assorted956601assorted
absented1156612absented
adverted1336102adverted
alerted82512222a_lerted
asperated1239312asperated
aspersed11428292aspersed
assenter867702assenter
assert64922582assert__
assertedly1463042assertedly
asserters956392asserters
assertor865722assertor
asserts74311792assert_s
assessed945022assessed
assisted936232assisted
assorter866672assorter
assured858372assur_ed
averted112211612a_verted
basseted1136742basse_ted
bassetted1244692bassetted
deserted101012202deserted
disserted11109812disserted
exserted1636212exserted
inserted92413052inserted
reasserted1145412reasserted
abetted1058323a_betted
aborted10310423a_borted
abseiled1144733abseiled
absentee1067663absentee
absenter1086773absenter
absorbed1344263absorbed
absterged1353353absterged
accented13107773accented
accepted15105383accepted
accreted1336333accreted
acerated113113983a_cerated
acierated1238283acierated
adhered1239233adher_ed
adsorbed1243443adsorbed
advected1534533advected
aerated85322373a__erated
aeried74221863a__eried
affected1744793affected
agented939423a_gented
airted74214503a__irted
alerter72111513a_lerter
altered83215733alter_ed
amerced1256523a_merced
angered93013473anger_ed
ansated84214003ans_ated
answered1235493answer_ed
arrested939153arrested
ascared10399523ascar_ed
ascended1246513ascended
ashlered1244623ashler_ed
asperate10312373asperate_
asperates11312553asperates
asperges11318093asperges
asperse94210663asperse_
asperser10408303asperser
asperses104111673asperses
aspirated1247703aspirated
aspired1068173aspir_ed
assailed945323assailed
assaulted1042583assaulted
assayed1135593ass_ayed
assegaied1142503assegaied
assembled1443693assembled
assent65119953assent__
assenters966993assenters
assentor865293assentor
assents74512223assent_s
asserting1038663asserting
assertion946723assertion
assertive1246473assertive
assertors965973assertors
assesses737383assesses
asset55932263asse_t__
assets65617663asse_t_s
asseverated1552143asseverated
assigned1044633assigned
assister836753assister
assoiled935023assoiled
assort64916383assort__
assorters965733assorters
assorts73310153assort_s
assuaged1044383assuaged
assumed1065293ass_umed
assure6610773assur_e_
assureds984493assur_eds
assurer767793assur_er
assures7611403assur_es
asswaged1343333asswaged
asteriated1177993asteriated
asteroid9511193asteroid
attested936293attested
averred11237593a_verred
averter102410553a_verter
axseed1456993axse__ed
bisected1336203bisected
caseated11310713caseated
casketed1534953caske_ted
cassette1047813cassette_
cassettes1146703cassettes
cosseted1178343cosse_ted
deserter91211603deserter
deserved13108133deserved
disseated11711083disseated
dissected13108663dissected
dissented1199723dissented
disserved14107003disserved
diverted13199583diverted
enserfed1245193enserfed
escorted1136703escorted
everted112711853_everted
exerted152210053_exerted
experted1838053experted
exsected1835673exsected
gusseted1043553gusse_ted
inserter82312133inserter
insetted9249023insetted
inverted122312163inverted
isleted837523isle_ted
kashered1636403kasher_ed
masseter1037063masse_ter
mastered112614003master_ed
misseated12610113misseated
missorted1247033missorted
nauseated1045233nauseated
observed1444373observed
obverted1435103obverted
osiered837123osier_ed
passepied1442933passepied
reassorted1144363reassorted
reseated93220263reseated
resected112514743resected
resented92716963resented
reserved121010583reserved
resorted9313493resorted
reverted122714713reverted
sabered103213023saber_ed
scarted104816123_scarted
scented102811883_scented
seated75131053__seated
sered65737293__ser_ed
serged84118763__serged
served104616813__served
sheeted113813043_sheeted
shorted113614403_shorted
skirted12388613_skirted
sleeted83113223_sleeted
smarted105012613_smarted
smelted10399093_smelted
smerked14327283_smerked
snorted83813493_snorted
sorted74523713__sorted
spirted103913073_spirted
sported104015433_sported
spurted103111973_spurted
started84217323_started
stetted82610403_stetted
sweated113411543_sweated
swerved1455703_swerved
tasseled935593tasse_led
tasselled1044633tasselled
unseated91317683unseated
unserved12410233unserved
unsorted9312513unsorted
ushered1139153usher_ed
wadsetted1442623wadsetted

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 Limit1461621727.18620339.8
3Display Results1721720.0802150.0
 (SQL Overall)1786911727.68923239.8
 
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.