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

69 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
crassnesses124665(None) 
crossnesses1247121crossnesses
bassnesses1136842_bassnesses
brashnesses1646552brashnesses
brassinesses1346062brassinesses
classinesses1366112classinesses
crassness1136212crassne_s_s
crazinesses2237932crazinesses
crispnesses1545942crispnesses
grossnesses1146712grossnesses
rashnesses1338722_rashnesses
artsinesses1138713artsinesses
assesses737383__ass_esses
basenesses12310563_basenesses
biasnesses1236963bia_snesses
bravenesses1647953bravenesses
brisknesses1745583brisknesses
caginesses13310943c_aginesses
cakinesses16310613c_akinesses
calmnesses1436843c_almnesses
canonesses1238423c_anonesses
charinesses1639563charinesses
chastenesses1746313chastenesses
closenesses1347843closenesses
coarsenesses1447243coarsenesses
cosinesses121012823c_osinesses
craftinesses1746383craftinesses
cragginesses1644503cragginesses
crankinesses1846143crankinesses
cravennesses1744113cravennesses
creakinesses1845993creakinesses
creaminesses1646133creaminesses
crispinesses1645003crispinesses
crossness1137093crossne_s_s
crudenesses1476653crudenesses
cruelnesses1346253cruelnesses
crustinesses14137633crustinesses
drabnesses1336483dra_bnesses
dressinesses1245523dressinesses
easinesses10314443_easinesses
fastnesses1389083_fastnesses
frailnesses1447593frailnesses
franknesses1845603franknesses
freshnesses1746103freshnesses
gassinesses1197973_gassinesses
gastnesses11129143_gastnesses
glassinesses1255243glassinesses
grandnesses1348113grandnesses
grapinesses1438573grapinesses
gravenesses1548173gravenesses
graynesses1436143gra_ynesses
greasinesses1347043greasinesses
harshnesses1745853harshnesses
iratenesses11411443iratenesses
massinesses12128693_massinesses
pastnesses12910513_pastnesses
prissinesses1355953prissinesses
prosinesses13310853prosinesses
racinesses12313513_racinesses
ranknesses1438093_ranknesses
raptnesses1248523_raptnesses
rarenesses10313113_rarenesses
raspinesses1338013_raspinesses
rawnesses1288123_ra_wnesses
reassesses945063reass_esses
rosinesses101213143_rosinesses
sassinesses999323_sassinesses
trashinesses1546113trashinesses
vastnesses13128203_vastnesses

Search took 6 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 Filter1786911216330.393454684.5
2DLD Change Limit121633694.60626407.5
3Display Results69690.0461500.0
 (SQL Overall)178691695.04535419.4
 
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.