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

66 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
seaworthinesses216142(None) 
seaworthiness1962002seaworthine_s_s
airworthinesses2181403airworthinesses
earthinesses1545813_ea__rthinesses
swarthinesses1943453s__warthinesses
unworthinesses2052673_unworthinesses
worthinesses1845753___worthinesses
earthlinesses1643904_ea__rthlinesses
healthinesses1942964hea__lthinesses
heartinesses1547994hea__rt_inesses
savorinesses1544604s_avor__inesses
seaworthiest1851944seaworthi_e_s_t
sportinesses1447864s__port_inesses
starchinesses1843214sta__rchinesses
stealthinesses1751954stea__lthinesses
wealthinesses1942624wea__lthinesses
airworthiness1971705airworthine_s_s
artinesses10815195__a__rt_inesses
artsinesses1138705__a__rtsinesses
beastlinesses1563425bea__stlinesses
breathinesses1853655brea___thinesses
earlinesses11311035_ea__r_linesses
earthiness1377245_ea__rthine_s_s
frothinesses1845595__fro_thinesses
growthinesses2042605__growthinesses
lengthinesses1752145le__ngthinesses
marshinesses1744965_ma__rshinesses
meatinesses13311975mea___t_inesses
newsworthiness2371215newsworthine_s_s
peartnesses1338715pea__rt__nesses
portlinesses1446975___portlinesses
roadworthiness2171165roadworthine_s_s
saintlinesses1344365s_a_intlinesses
saltinesses11311445s_a__lt_inesses
scantinesses1437315sca__nt_inesses
scarinesses1339905sca__r__inesses
seaminesses13310755sea____minesses
seaworthier1751605seaworthi____er
shadowinesses2052145shado__winesses
shortnesses1446795s__hort__nesses
slatinesses11311615sla___t_inesses
slouchinesses1842805s__louchinesses
smarminesses1645105sma__r_minesses
smartnesses1337145sma__rt__nesses
smoothnesses1762655s__mooth_nesses
snootinesses1265795s__noot_inesses
snottinesses1255835s__no_ttinesses
sootinesses11410045s___oot_inesses
sorrinesses11310085s___or_rinesses
spottinesses1445685s__po_ttinesses
stalwartnesses1751295stalwart__nesses
storminesses1445025s__tor_minesses
swarthiness1743385s__warthine_s_s
swartnesses1436715s__wart__nesses
sweatinesses1546905s__weat_inesses
tartinesses111011495_ta__rt_inesses
tawdrinesses1643435_tawdr__inesses
tearinesses11311695tea__r__inesses
temporarinesses1961985temporarinesses
unearthlinesses1861855unea__rthlinesses
unworthiness1853245_unworthine_s_s
wearinesses14310215wea__r__inesses
wordinesses15138875___wor_dinesses
worminesses16127985___wor_minesses
worthiness1645915___worthine_s_s
yeastinesses1545565yea__st_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.1701051123.5
2DLD Change Limit65874665.70311550.8
3Display Results66660.0461434.8
 (SQL Overall)178691665.91930189.4
 
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.