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

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
unearthlinesses186185(None) 
earthlinesses1643902__earthlinesses
unearthliness1652392unearthline_s_s
earthinesses1545813__earth_inesses
unhealthinesses2161623unhealth_inesses
unworthinesses2052673unworth_inesses
beastlinesses1563424_beast_linesses
breathinesses1853654brea_th_inesses
earlinesses11311034__ear__linesses
earthliness14144144__earthline_s_s
healthinesses1942964_health_inesses
heartinesses1547994_heart__inesses
stealthinesses1751954stealth_inesses
swarthinesses1943454_swarth_inesses
unearthliest1552384unearthli_e_s_t
uneasinesses1246624unea___sinesses
ungainlinesses1562834unga_inlinesses
unmanlinesses1574304unma__nlinesses
unrulinesses1245804un__r_ulinesses
unsightlinesses1962214unsightlinesses
unwarinesses1546154unwar___inesses
unworldlinesses1991814unworldlinesses
wealthinesses1942624_wealth_inesses
artinesses10815195___art__inesses
artsinesses1138705___art_sinesses
blearinesses1446545blear___inesses
churchlinesses2451385_churchlinesses
cleanlinesses1553885clea__nlinesses
courtlinesses1544455_court_linesses
cowardlinesses2052515cowar_dlinesses
deadlinesses1446225_dea__dlinesses
drearinesses1347435drear___inesses
earthiness1377245__earth_ine_s_s
fearfulnesses1945315_fearful_nesses
fertilenesses1648005_fe_rtilenesses
ghastlinesses1742745_ghast_linesses
heavenlinesses2051795_heavenlinesses
inertnesses1198715ine_rt___nesses
knightlinesses2282445knight_linesses
lengthinesses1752145_length_inesses
marshinesses1744965__marsh_inesses
mealinesses13310975_mea___linesses
meatinesses13311975_mea_t__inesses
nastinesses111110725_n_ast__inesses
nattinesses11119315_n_a_t_tinesses
naughtinesses1752405_n_aughtinesses
nearnesses1039095_near____nesses
neatnesses10310005_nea_t___nesses
nerdinesses1249045_ne_r__dinesses
nervinesses1437305_ne_r__vinesses
neutralnesses1354335_neutral_nesses
peartnesses1338715_peart___nesses
portlinesses1446975__port_linesses
preachinesses2043745prea_ch_inesses
seaworthinesses2161425_seaworth_inesses
sneakinesses1645905snea___kinesses
starchinesses1843215_starch_inesses
statelinesses1344235_sta_telinesses
sweatinesses1546905swea_t__inesses
tartinesses111011495__tart__inesses
tearfulnesses1645525_tearful_nesses
tearinesses11311695_tear___inesses
towardlinesses1851915towar_dlinesses
unaptnesses1395525un_apt___nesses
uncanninesses1553135unca__nninesses
uncertainnesses1781355uncertainnesses
uncleanlinesses1792155uncleanlinesses
uncouthnesses1862805uncouth__nesses
unearthlier1451825unearthli____er
ungodlinesses1563305un__godlinesses
unhandinesses1753715unha__ndinesses
unhappinesses2052485unha__ppinesses
unharnesses1445425unhar____nesses
unhealthiness1962425unhealth_ine_s_s
unholinesses1544905un___holinesses
unkindlinesses1952565un_kindlinesses
unlawfulnesses2052985unlawful_nesses
unlikelinesses1852635un_likelinesses
unlovelinesses1752455un_lovelinesses
unreadinesses1484575un__readinesses
unseemlinesses1652285un_seemlinesses
untidinesses1345915un___tidinesses
untimelinesses16103185un_timelinesses
unwashednesses21112145unwa_shednesses
unworthiness1853245unworth_ine_s_s
weaklinesses1944485_wea__klinesses
wearinesses14310215_wear___inesses
worthinesses1845755__worth_inesses
yeastinesses1545565_yeast__inesses

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 Filter178691658740.0931921408.6
2DLD Change Limit65874898.1238109.6
3Display Results89890.0631412.7
 (SQL Overall)178691898.27921583.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.