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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
accosted134554(None) 
accented13107802accented
accepted15105412accepted
accessed1385422accessed
accorded14155372accorded
accost101112262accost__
accosts11107992accost_s
accounted1444832accounted
accouter1245372accouter
accoutred1443372accoutred
accreted1336352accreted
accused12368432accus_ed
costed95623122__costed
aborted10310423a_borted
acceded1336123acc_eded
acceptee14105753acceptee
accepter14144963accepter
accesses1287503accesses
accolade1346053accolade
accoladed1543953accoladed
accord1178843acco__rd
accorder1395253accorder
accosting1446733accosting
accoutered1542783accoutered
accouters1344873accouters
accoutre1244203accoutre
accoutres1344383accoutres
accrete1137853accrete_
accretes1238133accretes
accrued1233833acc_rued
accursed1354643accursed
accuse103411033accus_e_
accuser11347933accus_er
accuses114112193accus_es
accustom1443663accustom
accustomed1752163accustomed
acerated113114003acerated
acetated112010693acetated
acorned10238283a_corned
acrostic1239943acrostic
acted88521743a_c__ted
actuated1138753actuated
acylated1437883acylated
adjusted1743613adjusted
adopted1136263a_dopted
agisted938203a_gisted
alcoved1375623alco_ved
allotted986873allotted
apposed1247853appos_ed
arcuated1138813arcuated
arrested939173arrested
assisted936233assisted
assorted956603assorted
attested936313attested
azoted16388593a_zo_ted
baccated15148383bacc_ated
boosted104111983_boosted
caboshed1634393caboshed
cacheted16148243cacheted
cavorted1435693cavorted
chested133811683_chested
cisted95217523__cisted
closed95317973_clos_ed
closeted1135613_closeted
clotted104011823_clotted
clouted104212163_clouted
coasted104015963_coasted
coated94927043__coated
cohosted1436143cohosted
coopted123710783_coopted
coshed124217553__coshed
cosied94819893__cosied
coster84331293__coster
coted85033853__co_ted
crested103416553_crested
crossed105313903_crossed
crusted103712763_crusted
decocted1437693decocted
encysted1444303encysted
escorted1136703escorted
escoted1038183esco_ted
frosted113211883_frosted
ghosted1236273_ghosted
hosted105020343__hosted
imposted13257403imposted
occulted1344273occulted
picoted1239213pico_ted
posted93722493__posted
recoated113416793recoated
riposted11216943riposted
roosted83211893_roosted
scooted103612283_scooted
scouted104112033_scouted
uncoated11314963uncoated
unposted1159433unposted

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.436409841.7
2DLD Change Limit146162957.50019488.3
3Display Results95950.0303166.7
 (SQL Overall)178691957.96622431.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.