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

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

49 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
colorfastness186125(None) 
colorfastnesses2061302colorfastnesses
colorfulness1753823colorf_ulness
colorlessness1553903colorlessness
colonialness1453464colonia_lness
colorcasted1652354colorcast_e_d
colorcasts1444244colorcast___s
colorfast1445034colorfast____
dolorousness1355354dolorous_ness
boorishness1644245bo_or_ishness
canorousness1456805canorous_ness
chloracnes1744445chlor_a_cne_s
chloramines1845525chlor_amine_s
chlorates142512275chlor_a_t_e_s
chlordanes1644515chlorda__ne_s
cloddishness1952505c_loddishness
cloistress1242715c_lo__istress
closeness1137615c_lo___seness
clownishness2052285c_lownishness
coarseness1246175co_ar__seness
cohostess1443455coho___st_ess
colocates13312855colo_ca_t_e_s
colorants1149865color_a__n_ts
colorations13911895color_a_tions
coloraturas1352735color_a_turas
colorcast1346555colorcast____
colorcasting1752305colorcast_ing
colorfulnesses1993835colorf_ulnesses
colorimeters1653165colorimet_ers
colorists112313595color_ist___s
colorless1145685color____less
colorlessnesses1665095colorlessnesses
coltishness1645045col__tishness
compactness1953305c__ompactness
contrariness1455485contr_ariness
corporealness1762015corporea_lness
correctness1553815c__orrectness
corruptness1552755c__orruptness
cotoneasters1452315cotoneast_ers
covertness1545505cover___tness
crassness1136215c___r_assness
fastness11238765_____fastness
ignorantness13111865ignor_antness
lightfastness2061315lightfastness
lostness837685__lo___stness
odorousness1245895_odorous_ness
sonorousness1256275sonorous_ness
steadfastness176855steadfastness
wolfishness2043735wol__fishness

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit124790498.53314624.4
3Display Results49490.0301633.3
 (SQL Overall)178691498.95319958.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.