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

84 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
brassinesses134607(None) 
bassnesses1136842b_ass_nesses
bossinesses12117352b_ossinesses
braininesses1446552braininesses
brashnesses1646552bra_shnesses
brassiness1235492brassine_s_s
brattinesses1466262brattinesses
brawninesses1744702brawninesses
classinesses1366112classinesses
crassnesses1246652crass_nesses
dressinesses1245532dressinesses
gassinesses1197982_gassinesses
glassinesses1255252glassinesses
massinesses12128692_massinesses
prissinesses1355972prissinesses
raspinesses1338012_raspinesses
sassinesses999322_sassinesses
trashinesses1546112trashinesses
artsinesses1138733ar_tsinesses
ashinesses1339163__ashinesses
bagginesses1545953b_agginesses
balkinesses1767503b_alkinesses
balminesses1537253b_alminesses
bandinesses14109733b_andinesses
basenesses12310563b_a_senesses
battinesses13169453b_attinesses
bawdinesses17126323b_awdinesses
beadinesses1449563bea_dinesses
beastlinesses1563423beastlinesses
biasnesses1236963bia_s_nesses
boskinesses17136813b_oskinesses
brassieres12274383brassi_e_res
bravenesses1647953bra_venesses
brazennesses2343283brazennesses
breathinesses1853673breathinesses
breezinesses2343943breezinesses
brininesses1339003br_ininesses
brisknesses1745593br_isknesses
broodinesses1544743broodinesses
bushinesses16107473b_ushinesses
businesses121411393b__usinesses
bustinesses131310103b_ustinesses
craftinesses1746383craftinesses
cragginesses1644503cragginesses
crankinesses1846143crankinesses
crazinesses2237933cra_zinesses
crispinesses1645013crispinesses
crossnesses1247123cross_nesses
crustinesses14137643crustinesses
draftinesses1645753draftinesses
drowsinesses1644393drowsinesses
easinesses10314443_ea_sinesses
flashinesses18124863flashinesses
friskinesses1944783friskinesses
frostinesses1546533frostinesses
fussinesses13126943_fussinesses
glossinesses1254503glossinesses
graininesses1346603graininesses
grapinesses1438583gra_pinesses
greasinesses1347063greasinesses
grislinesses1345843grislinesses
grossnesses1146723gross_nesses
hastinesses141210693_hastinesses
marshinesses1744963marshinesses
messinesses1297513_messinesses
mossinesses12117463_mossinesses
mussinesses12147443_mussinesses
nastinesses111110743_nastinesses
pastinesses13911713_pastinesses
prosinesses13310863pr_osinesses
racinesses12313513_ra_cinesses
raininesses11310493_raininesses
randinesses121311203_randinesses
ranginesses121210113_ranginesses
rashnesses1338723_ra_shnesses
riskinesses1537843_riskinesses
rosinesses101213153_r_osinesses
rustinesses11911563_rustinesses
sissinesses9118323_sissinesses
tastinesses111110783_tastinesses
trustinesses12116993trustinesses
washinesses1737263_washinesses
waspinesses1636703_waspinesses
yeastinesses1545563yeastinesses

Search took 5 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 Filter178691950240.360496363.9
2DLD Change Limit95024843.81024940.7
3Display Results84840.0501680.0
 (SQL Overall)178691844.22042343.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.