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

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

89 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
unearthlinesses1861851unearthlinesses_
earthlinesses1643913__earthlinesses_
unearthliness1652393unearthline_s_s_
earthinesses1545824__earth_inesses_
unhealthinesses2161624unhealth_inesses_
unworthinesses2052674unworth_inesses_
beastlinesses1563425_beast_linesses_
breathinesses1853675brea_th_inesses_
earlinesses11311045__ear__linesses_
earthliness14144145__earthline_s_s_
healthinesses1942965_health_inesses_
heartinesses1548005_heart__inesses_
stealthinesses1751955stealth_inesses_
swarthinesses1943455_swarth_inesses_
unearthliest1552385unearthli____est
uneasinesses1246625unea___sinesses_
ungainlinesses1562835unga_inlinesses_
unmanlinesses1574315unma__nlinesses_
unrulinesses1245815un__r_ulinesses_
unsightlinesses1962215unsightlinesses_
unwarinesses1546155unwar___inesses_
unworldlinesses1991815unworldlinesses_
wealthinesses1942625_wealth_inesses_
artinesses10815226___art__inesses_
artsinesses1138736___art_sinesses_
blearinesses1446546blear___inesses_
churchlinesses2451396_churchlinesses_
cleanlinesses1553886clea__nlinesses_
courtlinesses1544466_court_linesses_
cowardlinesses2052516cowar_dlinesses_
deadlinesses1446226_dea__dlinesses_
drearinesses1347446drear___inesses_
earthiness1377246__earth_ine_s_s_
fearfulnesses1945316_fearful_nesses_
fertilenesses1648036_fe_rtilenesses_
ghastlinesses1742746_ghast_linesses_
heavenlinesses2051806_heavenlinesses_
inertnesses1198726ine_rt___nesses_
knightlinesses2282446knight_linesses_
lengthinesses1752146_length_inesses_
marshinesses1744966__marsh_inesses_
mealinesses13310976_mea___linesses_
meatinesses13311986_mea_t__inesses_
nastinesses111110746_n_ast__inesses_
nattinesses11119326_n_a_t_tinesses_
naughtinesses1752416_n_aughtinesses_
nearnesses1039116_near____nesses_
neatnesses10310016_nea_t___nesses_
nerdinesses1249056_ne_r__dinesses_
nervinesses1437326_ne_r__vinesses_
neutralnesses1354356_neutral_nesses_
peartnesses1338746_peart___nesses_
portlinesses1446996__port_linesses_
preachinesses2043756prea_ch_inesses_
seaworthinesses2161436_seaworth_inesses_
sneakinesses1645906snea___kinesses_
starchinesses1843216_starch_inesses_
statelinesses1344236_sta_telinesses_
sweatinesses1546916swea_t__inesses_
tartinesses111011506__tart__inesses_
tearfulnesses1645536_tearful_nesses_
tearinesses11311696_tear___inesses_
towardlinesses1851916towar_dlinesses_
unaptnesses1395526un_apt___nesses_
uncanninesses1553136unca__nninesses_
uncertainnesses1781356uncertainnesses_
uncleanlinesses1792156uncleanlinesses_
uncouthnesses1862816uncouth__nesses_
unearthlier1451826unearthli____e_r
ungodlinesses1563316un__godlinesses_
unhandinesses1753716unha__ndinesses_
unhappinesses2052486unha__ppinesses_
unharnesses1445436unhar____nesses_
unhealthiness1962426unhealth_ine_s_s_
unholinesses1544916un___holinesses_
unkindlinesses1952566un_kindlinesses_
unlawfulnesses2052986unlawful_nesses_
unlikelinesses1852636un_likelinesses_
unlovelinesses1752466un_lovelinesses_
unreadinesses1484586un__readinesses_
unseemlinesses1652286un_seemlinesses_
untidinesses1345916un___tidinesses_
untimelinesses16103186un_timelinesses_
unwashednesses21112146unwa_shednesses_
unworthiness1853246unworth_ine_s_s_
weaklinesses1944486_wea__klinesses_
wearinesses14310216_wear___inesses_
worthinesses1845766__worth_inesses_
yeastinesses1545566_yeast__inesses_

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 Filter178691658740.330541487.9
2DLD Change Limit65874895.26612509.3
3Display Results89890.0761171.1
 (SQL Overall)178691895.67231504.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.