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

73 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
graininesses134659(None) 
braininesses1446551braininesses
raininesses11310481_raininesses
brawninesses1744702brawninesses
brininesses1338982br_ininesses
graininess1145792grainine_s_s
grandnesses1348112gra_ndnesses
grapinesses1438572gra_pinesses
griminesses14167552gr_iminesses
airinesses102613613__airinesses
braininess1246123brainine_s_s
brassinesses1346063brassinesses
brattinesses1466263brattinesses
canninesses1368853_canninesses
craftinesses1746383craftinesses
cragginesses1644503cragginesses
crankinesses1846143crankinesses
crazinesses2237933cra_zinesses
dailinesses1249493_dailinesses
daintinesses1346243_daintinesses
daringnesses1464833daringnesses
draftinesses1645753draftinesses
faintnesses1447143_faintnesses
frailnesses1447593frai_lnesses
franknesses1845603fra_nknesses
fruitinesses1546443fruitinesses
gabbinesses1634903g_abbinesses
gaminesses13410463g_a_minesses
garishnesses1645883garishnesses
gassinesses1197973g_assinesses
gaudinesses1337853g_audinesses
gauntnesses1245173g_auntnesses
gauzinesses2136043g_auzinesses
gawkinesses1935633g_awkinesses
glarinesses1239513gla_rinesses
glaringnesses1553393glaringnesses
glassinesses1255243glassinesses
glazinesses2136403gla_zinesses
gracilenesses1655163gracilenesses
graphicnesses2151843graphicnesses
graspingnesses1852053graspingnesses
gravenesses1548173gra_venesses
graynesses1436143gra__ynesses
greasinesses1347043greasinesses
greedinesses1446463greedinesses
greennesses1247033green_nesses
grimnesses13106533gr_i_mnesses
grislinesses1345823grislinesses
grittinesses1345843grittinesses
grogginesses1544073grogginesses
growlinesses1644723growlinesses
grubbinesses1743283grubbinesses
grumpinesses1743663grumpinesses
hairinesses14198943_hairinesses
plainnesses1356203plain_nesses
quaintnesses2143823quaintnesses
racinesses12313513_ra_cinesses
raininess949273_rainine_s_s
randinesses121311203_randinesses
ranginesses121210113_ranginesses
ranknesses1438093_ra_nknesses
raspinesses1338013_raspinesses
riminesses121211413_r_iminesses
runninesses11137693_runninesses
scrawninesses1842423scrawninesses
shininesses1448293_shininesses
spininesses1358453_spininesses
tawninesses1436153_tawninesses
tininesses10311163__tininesses
trashinesses1546113trashinesses
vainnesses1337343_vain_nesses
whininesses1746183_whininesses
zaninesses19310383_za_ninesses

Search took 4 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 Limit95024733.33028535.7
3Display Results73730.0461587.0
 (SQL Overall)178691733.73647829.5
 
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.