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

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

100 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
crunchinesses205286(None) 
crunchiness1843282crunchine_s_s
paunchinesses2042342paunchinesses
raunchinesses1842632raunchinesses
chancinesses1945033chanc_inesses
churchlinesses2451393churchlinesses
crankinesses1846143cran_kinesses
crumblinesses1952893crumblinesses
crumminesses1843653cru_mminesses
crustinesses14137633cru_stinesses
cushinesses16127413c_u_shinesses
grouchinesses1942653grouchinesses
preachinesses2043753preachinesses
runninesses11137693_run_ninesses
runtinesses111210963_run_tinesses
scratchinesses2151763scratchinesses
touchinesses1744243tou_chinesses
achinesses1539304___achinesses
archnesses1547174ar__ch_nesses
bitchinesses1943524_bitchinesses
breathinesses1853674breathinesses
brininesses1338984brin__inesses
bushinesses16107464_bu_shinesses
butchnesses1843704_butch_nesses
canninesses1368854c_an_ninesses
chubbinesses2142604chu_bbinesses
chumminesses2142864chu_mminesses
clubbinesses1843154clu_bbinesses
clumsinesses1644774clu_msinesses
cockinesses1947564c__ockinesses
corninesses13410594corn__inesses
courtlinesses1544464courtlinesses
craftinesses1746384cr_aftinesses
cragginesses1644504cr_agginesses
crazinesses2237934cr__azinesses
creakinesses1845994cr_eakinesses
creaminesses1646134cr_eaminesses
creepinesses1645254cr_eepinesses
crispinesses1645004cr_ispinesses
crotchetinesses2261084crotchetinesses
crudenesses1476654cru__denesses
cruelnesses1346254cru__elnesses
crunchiest1764794crunchi_e_s_t
curlinesses1338734c_u_rlinesses
cursorinesses1553294cursorinesses
drunkennesses1861854drunkennesses
fancinesses1638144_fanc_inesses
frothinesses1845594fr_othinesses
fruitinesses1546444fru_itinesses
funkinesses18137004_fun_kinesses
funninesses14106874_fun_ninesses
gauchenesses1843324gau_chenesses
growthinesses2042604growthinesses
grubbinesses1743284gru_bbinesses
grumpinesses1743664gru_mpinesses
gushinesses15127024_gu_shinesses
hungrinesses1643854_hungrinesses
itchinesses1644614__itchinesses
jauntinesses1944684jaun_tinesses
juicinesses2035894_juic_inesses
luckinesses1746654_lu_ckinesses
muchnesses1744714_mu_ch_nesses
mushinesses16127324_mu_shinesses
ornerinesses1246574or_nerinesses
patchinesses1944364_patchinesses
paunchiness1842344paunchine_s_s
pluckinesses2043994plu_ckinesses
plushinesses1744724plu_shinesses
princelinesses1892724princelinesses
puninesses121110754_pun__inesses
punkinesses17127224_pun_kinesses
pushinesses1697334_pu_shinesses
racinesses12313514_r_ac_inesses
rancidnesses1544884_rancidnesses
randinesses121311204_ran_dinesses
ranginesses121210114_ran_ginesses
raunchiness1642884raunchine_s_s
richnesses1537804_r_ich_nesses
rockinesses1737364_r_ockinesses
ruddinesses1336034_ru_ddinesses
rustinesses11911554_ru_stinesses
ruttinesses11128994_ru_ttinesses
saucinesses1338984sau_c_inesses
scruffinesses2151564scru_ffinesses
sketchinesses2251884sketchinesses
slouchinesses1842804slouchinesses
slushinesses1445474slu_shinesses
spunkinesses1844384spun_kinesses
squashinesses2442384squashinesses
squishinesses2442944squishinesses
starchinesses1843214starchinesses
staunchnesses1851464staunch_nesses
suchnesses1536674_su_ch_nesses
sunninesses11148384_sun_ninesses
tetchinesses1753554_tetchinesses
trashinesses1546114tr_ashinesses
trendinesses1346324tren_dinesses
trickinesses1845224tr_ickinesses
trustinesses12116984tru_stinesses
yuckinesses2044764_yu_ckinesses

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 Filter178691950240.346516448.0
2DLD Change Limit950241005.15618429.8
3Display Results1001000.0601666.7
 (SQL Overall)1786911005.56232127.1
 
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.