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

81 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
crumblinesses195289(None) 
crumbliness1742572crumbline_s_s
crumminesses1843652crum_minesses
chubbinesses2142603chu_bbinesses
chumminesses2142863chum_minesses
clubbinesses1843153clu_bbinesses
clumsinesses1644773clum_sinesses
comelinesses1666403c_omelinesses
courtlinesses1544463courtlinesses
cruelnesses1346253cru_el_nesses
crunchinesses2052863crunchinesses
crustinesses14137633cru_stinesses
curablenesses17146993curablenesses
curlinesses1338733c_u_rlinesses
grubbinesses1743283gru_bbinesses
grumpinesses1743663grum_pinesses
humblenesses1944973_humblenesses
bumpinesses17126374_bum_pinesses
burlinesses1338404_bu_rlinesses
campinesses1737114c_am_pinesses
capablenesses1955454capablenesses
chillinesses1744984c_hillinesses
churchlinesses2451394churchlinesses
clamminesses1873794clam_minesses
cleanlinesses1553884cleanlinesses
comfinesses1846914c_om_finesses
costlinesses1446254c_ostlinesses
crabbednesses2072944crabbednesses
craftinesses1746384cr_aftinesses
cragginesses1644504cr_agginesses
crankinesses1846144cr_ankinesses
crazinesses2237934cr__azinesses
creakinesses1845994cr_eakinesses
creaminesses1646134cr_eaminesses
creepinesses1645254cr_eepinesses
crispinesses1645004cr_ispinesses
crudenesses1476654cru__denesses
crumbliest1643904crumbli_e_s_t
crumblings1742514crumblin___gs
crumminess1643694crum_mine_s_s
cursorinesses1553294cursorinesses
cushinesses16127414c_u_shinesses
doublenesses1546514dou_blenesses
dumbnesses1584604_dumb__nesses
dumpinesses16126254_dum_pinesses
durablenesses16156584durablenesses
equablenesses2465534equablenesses
fruitinesses1546444fru_itinesses
griminesses14167554grim__inesses
grislinesses1345824gr_islinesses
gristlinesses1443994gristlinesses
growlinesses1644724gr_owlinesses
gumminesses1634934_gum_minesses
homelinesses1765364_homelinesses
humpinesses18106244_hum_pinesses
jumpinesses22125344_jum_pinesses
lumpinesses15107114_lum_pinesses
nimblenesses1656014_nimblenesses
nubbinesses1544294_nu_bbinesses
numbnesses1474694_numb__nesses
orderlinesses1453394orderlinesses
plumbnesses1753074plumb__nesses
pricklinesses2143624pricklinesses
publicnesses1842664_pu_blicnesses
riminesses121211414_rim__inesses
ruddinesses1336034_ru_ddinesses
runninesses11137694_ru_nninesses
runtinesses111210964_ru_ntinesses
rustinesses11911554_ru_stinesses
ruttinesses11128994_ru_ttinesses
scruffinesses2151564scru_ffinesses
seemlinesses1445224seem_linesses
snubbinesses1643394snu_bbinesses
surlinesses11310054_su_rlinesses
timelinesses1445454_timelinesses
trustinesses12116984tru_stinesses
tubbinesses1544384_tu_bbinesses
uglinesses1138544__u_glinesses
unrulinesses1245804unru__linesses
wobblinesses1943054_wobblinesses
yumminesses1843874_yum_minesses

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.343520965.0
2DLD Change Limit95024815.01618944.2
3Display Results81810.0461760.9
 (SQL Overall)178691815.40533060.3
 
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.