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

86 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
threadier135447(None) 
threader1256731thread_er
headier113212952_h_eadier
readier83117422__readier
threaded1366322thread_ed
threaders1365742thread_ers
threadiest1444282threadiest
threading14107592threading
threaper1345142threa_per
throatier1244542throatier
treader84113832t_read_er
treadler936862t_readler
trendier937912t_rendier
unreadier1045012unreadier
beadier103513913__beadier
creakier14328333_creakier
creamier12319063_creamier
creasier103210193_creasier
dreamier11287293_dreamier
drearier9297923_drearier
freakier15246483_freakier
greasier9298083_greasier
greedier1036083_greedier
grenadier1144093_grenadier
header104422543_h_ead_er
heavier13429423_h_eavier
leadier83212723__leadier
phreaker1735053phrea_ker
reader73628293__read_er
readied93316623__readied
readies83324713__readies
reedier83815303__reedier
shadier113111153sh__adier
shredder1334393shre_dder
shrewder1534393shrewd_er
shrewdie1542983shrewdie_
shrewdies1643733shrewdies
spreader1137473spread_er
steadier937313_steadier
streakier1334843streakier
streamier1155763streamier
tardier859719993tar__dier
tearier73815613t__earier
theater104014253th_ea_ter
therapies1447723therapies
thereafter1642573thereafter
thewier1336063th_e_wier
thrasher1455743thr_asher
thread105011093thread___
threadbare1651363threadbare
threadfin1641953threadfin
threadfins1741963threadfins
threadiness1543463threadiness
threadless1442473threadless
threadlike1841943threadlike
threads11419953thread__s
threadworm1951443threadworm
thready14435903thread__y
threaped1454863threa_ped
threapers1444773threa_pers
threaping15106113threaping
threated1259203threa_ted
threaten1146303threa_ten
threatener1342933threatener
threating131010043threating
threnodies1443923threnodies
thresher1455823thre_sher
thriftier1542853thriftier
thrummier1641793thrummier
tireder837703tire_d_er
toreador944993toread_or
trader75218763t_r_ad_er
treaclier1144153t_reaclier
treaded95014283t_read_ed
treaders93311843t_read_ers
treading103515333t_reading
treadle8310103t_readle_
treadled1067123t_readled
treadlers1045893t_readlers
treadles939703t_readles
treater74219833t_rea_ter
treaties8316983t_reaties
trendies9312213t_rendies
tressier847963t_ressier
tweakier1533143t_weakier
tweedier1253623t_weedier

Search took 8 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 Filter1786911486410.1701051123.5
2DLD Change Limit148641867.28320409.3
3Display Results86860.0302866.7
 (SQL Overall)178691867.48323879.6
 
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.