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 “assented” 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
assented95751(None) 
absented1156611absented
assenter867701assenter
asserted957901asserted
absentee1067662absentee
absenter1086772absenter
accented13107772accented
agented939422a_gented
ascended1246512ascended
assent65119952assent__
assenters966992assenters
assentor865292assentor
assents74512222assent_s
asserter877562asserter
assessed945022assessed
assisted936232assisted
assorted956592assorted
basseted1136742basse_ted
bassetted1244692bassetted
dissented1199712dissented
resented92716962resented
scented102811882_scented
abetted1058323a_betted
abseiled1144733abseiled
absence1137693absence_
absences1247673absences
absent84016993absent__
absentees1164533absentees
absenters1156173absenters
absently1345813absently
absents93510723absent_s
accepted15105373accepted
advected1534533advected
adverted1336103adverted
affected1744793affected
alerted82512223a_lerted
alienated1047743alienated
aliened81011743alien_ed
alimented1245313alimented
amended11328303a_mended
amounted1135533amounted
anointed938343anointed
ansated84214003ans_ated
anted66328243a___nted
appended1435483appended
arointed939003arointed
aroynted1244523aroynted
arrested939153arrested
arsenate81010483arsenate_
arsenates979363arsenates
arsenide9116333arsenide
arsenite8119663arsenite_
arsenites9149163arsenites
ascend9429733ascen__d
ascender1136733ascender
ascent84519653ascent__
ascents93812553ascent_s
asperated1239313asperated
aspersed11428293aspersed
assailed945323assailed
assaulted1042583assaulted
assayed1135593ass_ayed
assegaied1142503assegaied
assembled1443683assembled
assenting1038163assenting
assentive1245743assentive
assentors955653assentors
assert64922573assert__
assertedly1463043assertedly
asserters956383asserters
assertor865713assertor
asserts74311793assert_s
assesses737383assesses
asset55932263asse_t__
assets65617663asse_t_s
assigned1044633assigned
assister836753assister
assoiled935013assoiled
assorter866663assorter
assuaged1044383assuaged
assumed1065293ass_umed
assured858373ass_ured
asswaged1343333asswaged
astonied978983astonied
attended1035763attended
attested936293attested
augmented1343833augmented
avenged1245503a_venged
averted112211613a_verted
axseed1456993axse__ed
bisected1336203bisected
caseated11310713caseated
casketed1534953caske_ted
cassene93111543cassen_e_
cassenes103611293cassen_es
cassette1047813cassette_
cassettes1146703cassettes
cemented1338373cemented
consented12311943consented
cosseted1178343cosse_ted
demented12311273demented
dented84120513__dented
deserted101012203deserted
disseated11711073disseated
dissected13108653dissected
dissenter1059133dissenter
disserted11109803disserted
essence947663essence_
essences1047563essences
exsected1835673exsected
exserted1636213exserted
fastened12257853fasten_ed
fomented1437803fomented
garmented1345883garmented
gusseted1043553gusse_ted
hastened12239103hasten_ed
hented104218753__hented
incented112412543incented
indented101811733indented
inserted92413053inserted
insetted9249023insetted
invented122510663invented
isleted837523isle_ted
lamented1138193lamented
lessened935093lessen_ed
lisente71210703lisente_
margented1346813margented
masseter1037063masse_ter
misenter10310833misenter
misseated12610113misseated
nauseated1045233nauseated
oriented937483oriented
parented11912213parented
passenger1243413passenger
passepied1442923passepied
patented1188893patented
presented12311613presented
reasserted1145403reasserted
relented92614943relented
rented74426593__rented
repented112614983repented
rerented92516163rerented
reseated93220263reseated
resected112514743resected
sainted84114243_sainted
scanted104114393_scanted
scended11329873_scended
seated75131053__seated
sended85121233__sended
sensed73918163__sensed
sente56432873__sente_
sheeted113813033_sheeted
shunted11339773_shunted
sklented1335053sklented
slanted83514743_slanted
sleeted83113223_sleeted
smelted10399093_smelted
stetted82610403_stetted
stinted82914193_stinted
stunted83010403_stunted
sweated113411543_sweated
talented938423talented
tasseled935583tasse_led
tasselled1044623tasselled
tented74221003__tented
undented102313953undented
unrented92413923unrented
unscented1237513unscented
unseated91317683unseated
untented92613413untented
vented104617923__vented
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.1731032896.0
2DLD Change Limit1461621727.09320606.5
3Display Results1721720.0762263.2
 (SQL Overall)1786911727.34224338.2
 
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.