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

124 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
threaper134514(None) 
threader1256731threader
threaped1454861threaped
threapers1444771threapers
cheaper144010582ch_eaper
heaper114119522_h_eaper
phreaker1735052phreaker
reaper84223142__reaper
tarpaper1244602tarpaper
theater104014252th_eater
threaded1366322threaded
threaders1365732threaders
threadier1354472threadier
threap11569662threap__
threaps12488642threap_s
threated1259202threated
threaten1146302threaten
threeped1454372threeped
thresher1455822thresher
treader84113822t_reader
treater74219832t_reater
bereaver1346673bereaver
breaker133912923_breaker
cheapen14407623ch_eapen
cheater124816953ch_eater
cheeper143610743ch_eeper
creamer113714083_creamer
creaser94415723_creaser
creeper11339973_creeper
draper94315693_dr_aper
dreamer104110843_dreamer
greaser83913083_greaser
greater84416493_greater
hanaper1237133_hanaper
header104422543_h_eader
healer94221803_h_ealer
heaped124516903_h_eaped
heapers123616673_h_eapers
hearer94323643_h_earer
heater94828303_h_eater
heaver124819673_h_eaver
helper114313093_h_elper
hepper133412663_h_epper
leaper88118943__leaper
phreaked1834493phreaked
phreakers1834673phreakers
preaver121011613_preaver
raper74932753__r_aper
reader73628293__reader
realer63528593__realer
reamer84325213__reamer
reaped94122453__reaped
reapers93520453__reapers
rearer64928913__rearer
reaver94524733__reaver
repaper11310023__repaper
scraper114513403scr_aper
screamer12267873screamer
shaper114119933sh__aper
shearer104414683sh_earer
shredder1334393shredder
shrewder1534393shrewder
shrimper1544413shrimper
spreader1137473spreader
streaker12229473streaker
streamer10239503streamer
taper74829773t___aper
tarpapers1344273tarpapers
tearer64822903t__earer
teaser65421523t__easer
temper103914093t__emper
thaler94613103th__aler
thawer12489343th__awer
theaters114211893th_eaters
theatre10358493th_eatre
therapies1447713therapies
therapy1536613therap_y
thereafter1642573thereafter
thewier1336063th_ewier
thrasher1455733thrasher
thrave126010273thr_ave_
thraves13469713thr_aves
thrawed1435583thr_awed
thread105011093threa__d
threads11419953threa_ds
thready14435903threa_dy
threaping15106113threaping
threat95020463threa__t
threatener1342933threatener
threatens1254663threatens
threats104311673threa_ts
three87526913thre__e_
threep115910113thre__ep
threeps12687043threep_s
threes97117323thre__es
threshed1535643threshed
threshers1545413threshers
threshes1437383threshes
thriller1165553thriller
thriver13479123thr_iver
throated1247923throated
throatier1244543throatier
throbber1543203throbber
thrower1386993thr_ower
thrummer1542933thrummer
thruster1135793thruster
thumper14356953th_umper
tireder837703tire_der
toreador944983toreador
tracer84820233t_r_acer
trader75218753t_r_ader
tramper113812153t_ramper
trapes85024463t_r_apes
trapper113912793t_rapper
treaded95014283t_readed
treaders93311833t_readers
treadler936853t_readler
treated83618703t_reated
treaters83615823t_reaters
trekker1034733t_rekker
tripper113711923t_ripper
trooper94210353t_rooper
trouper93811413t_rouper
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.1701051123.5
2DLD Change Limit1461621247.30020022.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.51623774.7
 
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.