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

126 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
threaders136574(None) 
threader1256731threader_
threapers1444771threapers
treaders93311841t_readers
headers113819392_h_eaders
phreakers1834672phreakers
readers83823772__readers
shredders1463702shredders
spreaders1236492spreaders
theaters114211902th_eaters
threaded1366322threade_d
threadier1354472threadier_
threadless1442472threadless
threads11419952thread__s
threaper1345142threaper_
threatens1254662threatens
threshers1545422threshers
toreadors1045142toreadors
traders84316952t_r_aders
treader84113832t_reader_
treadlers1045892t_readlers
treaters83615842t_reaters
abraders1137343abr_aders
beaders104120183__beaders
beheaders1545153beheaders
bereavers1446123bereavers
breakers143810973_breakers
breeders11368893_breeders
cheaters133613513ch_eaters
cheders134512393ch_e_ders
coleaders1237823coleaders
creamers124111303_creamers
creasers103612823_creasers
dreamers11369003_dreamers
graders94716013_gr_aders
greasers93410253_greasers
header104422543_h_eader_
healers104319463_h_ealers
heapers123616673_h_eapers
hearers104319783_h_earers
heaters104225223_h_eaters
heavers133717193_h_eavers
heders104119763_h_e_ders
heeders114213743_h_eeders
herders113914123_h_erders
kneaders1384713_kneaders
leaders83819603__leaders
lipreaders1342843lipreaders
nonreaders1145433nonreaders
paraders113113113par_aders
pervaders1544433pervaders
phreaker1735053phreaker_
pleaders113210183_pleaders
preavers13910263_preavers
reader73628293__reader_
reamers94221083__reamers
reapers93520453__reapers
rearers74323563__rearers
reavers108320743__reavers
redders93615343__redders
renders83821673__renders
screamers13236253screamers
serenaders11204663serenaders
shaders115915553sh__aders
shearers113911323sh_earers
shedders13267433sh_edders
shielders1334763shielders
shredder1334393shredder_
shrewder1534393shrewder_
spreader1137473spreader_
streakers13218123streakers
streamers11228063streamers
tarpapers1344273tarpapers
tearers75218233t__earers
teasers75317243t__easers
tedders94010233t__edders
tenders83719723t__enders
thalers106212263th__alers
thawers13428483th__awers
theater104014253th_eater_
theatres11298633th_eatres
thrashers1565313thrashers
thraves13469713thr_ave_s
thread105011093thread___
threadbare1651363threadbare
threadfin1641953threadfin
threadfins1741963threadfins
threadiest1444283threadiest
threadiness1543463threadiness
threading14107593threading
threadworm1951443threadworm
threadworms2051373threadworms
thready14435903thread__y
threaped1454863threape_d
threaps12488643threa__ps
threated1259203threate_d
threaten1146303threate_n
threateners1452813threateners
threats104311673threa__ts
threeps12687043thre__eps
threes97117323thre__e_s
threnodes1354963threnode_s
thresher1455823thresher_
threshes1437383threshe_s
thrillers1244473thrillers
thrivers14456823thr_ivers
throbbers1643173throbbers
throwers14106033thr_owers
thrummers1642413thrummers
thrusters1245333thrusters
thunders1236953th_unders
tirades8311723tir_ade_s
tireder837703tire_der_
toreador944993toreador_
torsades937213torsade_s
tracers94917843t_r_acers
trader75218763t_r_ader_
trades75724503t_r_ade_s
treaded95014283t_reade_d
treadler936863t_readler_
treadles939703t_readles
treadless1036003t_readless
treads74817923t_read__s
treater74219833t_reater_
trekkers1133803t_rekkers
wreakers15328423_wreakers

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411269.03016460.8
3Display Results1261260.0632000.0
 (SQL Overall)1786911269.26619284.6
 
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.