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

63 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
unsightlinesses1962211unsightlinesses_
knightlinesses2282443kn_ightlinesses_
sightlinesses1743863__sightlinesses_
unsightliness1762513unsightline_s_s_
sprightlinesses2161824sprightlinesses_
almightinesses2051835almight_inesses_
flightinesses2053135_flight_inesses_
knightliness2052735kn_ightline_s_s_
mightinesses1844385__might_inesses_
naughtinesses1752415_naught_inesses_
sightliness1574565__sightline_s_s_
unearthlinesses1861855unearthlinesses_
ungodlinesses1563315un__godlinesses_
unholinesses1544915un___holinesses_
unkindlinesses1952565unki_ndlinesses_
unlikelinesses1852635unli_kelinesses_
unseemlinesses1652285uns_eemlinesses_
unsightliest1652195unsightli____est
untimelinesses16103185unti_melinesses_
uprightnesses19122785upright__nesses_
uptightnesses1982225uptight__nesses_
weightinesses2052905_weight_inesses_
benightednesses2262416benightednesses_
brightnesses1844186_bright__nesses_
costlinesses1446256cos___tlinesses_
delightednesses2162536delightednesses_
doughtinesses1852556_dought_inesses_
droughtinesses1951836drought_inesses_
gastightnesses19131826gastight__nesses_
gristlinesses1443996_gri_stlinesses_
haughtinesses2042166_haught_inesses_
lightnesses1546146__light__nesses_
niftinesses1437246_n_i_ft_inesses_
nighnesses1446466_n_igh___nesses_
nightdresses1752206_n_ight_dresses_
priestlinesses1652726_priestlinesses_
rightnesses1546236__right__nesses_
saintlinesses1344366__saintlinesses_
sicklinesses1844866__si_cklinesses_
sightlessness1654156__sightl__essness
sightlessnesses1755036__sightlessnesses_
sightlines1465756__sightlin___es_
sillinesses1169846__si__llinesses_
slightnesses1654626_slight__nesses_
sprightliness1962096sprightline_s_s_
tightnesses1565586__tight__nesses_
uglinesses1138546u___g__linesses_
uncleanlinesses1792156uncleanlinesses_
unfitnesses1446136unfi__t__nesses_
ungainlinesses1562836un_gainlinesses_
unhealthinesses2161626unhealthinesses_
unlovelinesses1752466un_lovelinesses_
unmanlinesses1574316un__manlinesses_
unrulinesses1245806un___rulinesses_
unsettlednesses16102206uns_ettlednesses_
unsightlier1551666unsightli____e_r
unstablenesses1656036uns_tablenesses_
unsteadinesses1553066uns_teadinesses_
untidinesses1345916unti___dinesses_
unwieldinesses1851936unwi_eldinesses_
unworldlinesses1991816unworldlinesses_
unworthinesses2052676un_worthinesses_
uppitinesses16103706uppi__t_inesses_

Search took 10 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.203880251.2
2DLD Change Limit65874638.7837500.2
3Display Results63630.093677.4
 (SQL Overall)178691639.07919681.8
 
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.