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

59 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
weaklinesses194448(None) 
deadlinesses1446222deadlinesses
earlinesses11311052_earlinesses
leakinesses1538472leak_inesses
mealinesses13310972mea_linesses
weakliness1753852weakline_s_s
weaknesses1735462weak__nesses
wearinesses14310212wea_rinesses
balkinesses1767503_balkinesses
beadinesses1449563bea_dinesses
beastlinesses1563423beastlinesses
cakinesses16310613_cak_inesses
cleanlinesses1553883cleanlinesses
creakinesses1845993creak_inesses
dailinesses1249493_dailinesses
easinesses10314443_ea_sinesses
flakinesses1837073flak_inesses
freakinesses1945593freak_inesses
geekinesses1635813geek_inesses
headinesses1539843hea_dinesses
heartinesses1548003heartinesses
heavinesses1747453hea_vinesses
jerkinesses2246053jerk_inesses
leafinesses1437873lea_finesses
manlinesses13910193_manlinesses
meatinesses13311983mea_tinesses
peakednesses1945043peakednesses
perkinesses1748933perk_inesses
peskinesses1746573pesk_inesses
quakinesses2436323quak_inesses
readinesses12611273rea_dinesses
realnesses10310853rea_l_nesses
scalinesses1339323sca_linesses
seaminesses13310753sea_minesses
seemlinesses1445223seemlinesses
shakinesses1837613shak_inesses
sicklinesses1844863sicklinesses
snakinesses1538553snak_inesses
sneakinesses1645903sneak_inesses
sweatinesses1546913swea_tinesses
talkinesses1537353_talkinesses
tearinesses11311693tea_rinesses
wackinesses2036653w_ackinesses
warinesses131514533w_a_rinesses
washinesses1737263w_ashinesses
waspinesses1636703w_aspinesses
wavinesses16199283w_a_vinesses
waxinesses20138763w_a_xinesses
wealthinesses1942623wealthinesses
weedinesses1557073we_edinesses
weepinesses1646133we_epinesses
wellnesses1335783we__llnesses
wifelinesses1844813wifelinesses
wilinesses131911093w__ilinesses
wobblinesses1943053wobblinesses
womanlinesses1843143womanlinesses
woolinesses14157503w_oolinesses
woollinesses15113793woollinesses
yeastinesses1545563yeastinesses

Search took 5 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.373479064.3
2DLD Change Limit95024593.95324038.5
3Display Results59590.0301966.7
 (SQL Overall)178691594.35641021.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.