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 “threader” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

162 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
threader125673(None) 
threaded1366321threaded
threaders1365741threaders
threadier1354471threadier
threaper1345141threaper
treader84113831t_reader
header104422542_h_eader
phreaker1735052phreaker
reader73628292__reader
shredder1334402shredder
shrewder1534402shrewder
spreader1137482spreader
theater104014252th_eater
thread105011092thread__
threads11419952thread_s
thready14435902thread_y
threaped1454862threaped
threapers1444772threapers
threated1259202threated
threaten1146302threaten
thresher1455822thresher
tireder837702tire_der
toreador945002toreador
trader75218762t_r_ader
treaded95014282t_readed
treaders93311842t_readers
treadler936862t_readler
treater74219832t_reater
abrader1038643abr_ader
beader94623793__beader
beheader1436043beheader
bereaver1346673bereaver
breaded115014063_breaded
breaker133912923_breaker
breeder103210043_breeder
broader103412613_broader
cheaper144010583ch_eaper
cheater124816963ch_eater
cheder125113493ch_e_der
coleader1139183coleader
creamer113714093_creamer
creaser94415743_creaser
deader84220473__deader
dreaded103612023_dreaded
dreamer104110843_dreamer
forrader1236153forrader
grader84919693_gr_ader
greaser83913083_greaser
greater84416493_greater
headed114020473_h_eaded
headers113819393_h_eaders
headier113212953_h_eadier
healer94221803_h_ealer
heaper114119523_h_eaper
hearer94323643_h_earer
heater94828303_h_eater
heaver124819673_h_eaver
heder95623643_h_e_der
heeder104216043_h_eeder
herder104516463_h_erder
kneader1275893_kneader
leader74824653__leader
lipreader1243293lipreader
nonreader1045913nonreader
parader103914863par_ader
pervader1444863pervader
phreaked1834493phreaked
phreakers1834673phreakers
pleader103511753_pleader
preaver121011613_preaver
readers83823773__readers
readier83117423__readier
realer63528593__realer
reamer84325213__reamer
reaper84223143__reaper
rearer64928913__rearer
reaver94524733__reaver
redder83918143__redder
render74024143__render
rethreaded1543273rethreaded
screamer12267883screamer
serenader10216003serenader
shader104218763sh__ader
shearer104414683sh_earer
shedder12339323sh_edder
shielder1235183shielder
shredded1444063shredded
shredders1463713shredders
spreaders1236503spreaders
streaker12229483streaker
streamer10239513streamer
tarpaper1244603tarpaper
tearer64822903t__earer
teaser65421523t__easer
tedder83312163t__edder
tender74121843t__ender
thaler94613103th__aler
thawer12489343th__awer
theaters114211903th_eaters
theatre10358493th_eatre
thereafter1642573thereafter
thereunder1452033thereunder
thewier1336063th_ewier
thrasher1455743thrasher
thrave126010273thr_ave_
thraves13469713thr_aves
thrawed1435583thr_awed
threadbare1651363threadbare
threadfin1641953threadfin
threadiest1444283threadiest
threading14107593threading
threadless1442473threadless
threadworm1951453threadworm
threap11569663threa__p
threaps12488643threa_ps
threat95020463threa__t
threatener1342933threatener
threatens1254673threatens
threats104311673threa_ts
three87526913thre__e_
threep115910113thre__ep
threeped1454373threeped
threes97117323thre__es
threnode1255423threnode_
threnodes1354963threnodes
threshed1535643threshed
threshers1545423threshers
threshes1437383threshes
thriller1165553thriller
thriver13479123thr_iver
throated1247923throated
throatier1244553throatier
throbber1543203throbber
thrower1386993thr_ower
thrummer1542933thrummer
thruster1135793thruster
thunder1136963th_under
tirade7311693tir_ade_
tirades8311723tir_ades
toreadors1045153toreadors
torrider936173torrider
torsade837593torsade_
torsades937213torsades
tracer84820233t_r_acer
trade65026043t_r_ade_
traded85717683t_r_aded
traders84316953t_r_aders
trades75724503t_r_ades
tread64821703t_read__
treadle8310103t_readle
treadled1067123t_readled
treadlers1045893t_readlers
treadles939703t_readles
treads74817923t_read_s
treated83618703t_reated
treaters83615843t_reaters
trekker1034733t_rekker
trended94011763t_rended
trendier937913t_rendier
unreadier1045013unreadier
unthreaded1543533unthreaded
wreaker143610043_wreaker

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621627.39319770.3
3Display Results1621620.0602700.0
 (SQL Overall)1786911627.87322696.7
 
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.