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

364 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
redacted1241024(None) 
reacted103015711re_acted
redated93120921reda_ted
deducted1356242deducted
enacted10310642_enacted
exacted1737302_exacted
preacted132710942pre_acted
predated12513272preda_ted
predicted1538912predicted
reached134619082re_ached
readapted1344802readapted
rebaited11410542rebaited
rebated103619692reba_ted
recanted112513512recanted
redact9419042redact__
redactor1147022redactor
redacts10510942redact_s
redate74124682reda_te_
redates83423862reda_tes
redbaited1344712redbaited
redocked16206822redocked
redrafted1435142redrafted
reduced11610322reduc_ed
reenacted1236852reenacted
refaced133713572refac_ed
refected142311662refected
refracted1557392refracted
rejected182710112rejected
relaced103517212relac_ed
related83327572rela_ted
relucted1138652relucted
remated103522472rema_ted
repacked17188742repacked
repasted112611532repasted
reracked15169122reracked
resected112514742resected
retacked15169272retacked
retasted92412112retasted
retracted12410952retracted
sedated93714342seda_ted
abducted1444093abducted
abreacted1444293abre_acted
acted88521733___acted
adapted1135833_adapted
addicted1345073addicted
adducted1343913adducted
aerated85322373aera_ted
beached154516553be_ached
bedamned1434583bedamned
bedaubed1443183bedaubed
bedecked1874573bedecked
bedotted1234983bedotted
belaced124112153belac_ed
belated103520013bela_ted
berated104422133bera_ted
bracted12410933_bracted
breached163411643bre_ached
breasted1138823bre_asted
cerated103922473cera_ted
coacted123611603_coacted
coenacted1445803coenacted
created104323443cre_a_ted
credited1238253cred_ited
cremated133412963crema_ted
crenated113013913crena_ted
darted84620923__darted
dated75530993__da_ted
dauted84114933__dauted
dawted11489683__dawted
debated113916083deba_ted
decanted122310493decanted
decocted1437683decocted
dedicated14310253dedicated
deduced1266683deduc_ed
defaced142910973defac_ed
defatted1335673defatted
defected15289973defected
dejected19307593dejected
delated93722873dela_ted
demasted1238763demasted
departed1238823departed
depicted1437743depicted
derated93623503dera_ted
deratted1048403deratted
desalted1038313desalted
detached1537733detached
detected12289733detected
detracted1357793detracted
ducted104012123__ducted
edited83913673_ed_ited
educated1237943_educated
educed10418853_educ_ed
ejected17297653_ejected
elated74725823_ela_ted
elected102812613_elected
erected103213993_erected
eructed10228653_eructed
evicted1337243_evicted
exacter1637403_exacter
exalted1537393_exalted
exapted1736073_exapted
feasted11310843fe_asted
foredated1447683foreda_ted
fracted1339373_fracted
gelated93615633gela_ted
gradated1157433grada_ted
hearted113314023he_arted
heated104525593he_a_ted
ideated9310973idea_ted
impacted15286353impacted
indicted1249203indicted
inducted1237273inducted
iodated9310023ioda_ted
leached133715043le_ached
legated92513983lega_ted
levanted1245323levanted
meated94222403me_a_ted
medaled113411603meda_led
medalled1246883medalled
mediated123011873mediated
medicated15410073medicated
menaced122710093menac_ed
misacted1338673misacted
negated93413233nega_ted
nidated939863nida_ted
outacted1139383outacted
overacted1539633overacted
peaced115818913pe_ac_ed
peached154315883pe_ached
pedaled113711873peda_led
pedalled1246903pedalled
pedate93117763peda_te_
pedicled1436453pedicled
preached163412063pre_ached
preadapted1643733preadapted
predate10616893preda_te_
predates11615803preda_tes
predicated1649143predicated
preenacted1544973preenacted
prefaced1638423prefac_ed
prelected1439123prelected
prepacked20155643prepacked
prepasted14137663prepasted
pretasted12147963pretasted
raced87635313r__ac_ed
racked134526083r__acked
radiated102512593radiated
radicated13410123radicated
rafted104714703r__afted
ranted74324703r__anted
rated65441383r__a_ted
ratted74923343r__atted
reaccede1354363re_accede
reacher123718293re_acher
reaches123423203re_aches
react74634333re_act__
reactor93011653re_actor
reacts83616603re_act_s
readded103310733re_added
readdicted1543363readdicted
readied93316623re_adied
readopted1344913readopted
realter73716313re_alter
reamed94326123re_a_med
reaped94122453re_a_ped
reared75930013re_a_red
rearmed103912823re_armed
reaved104523923re_a_ved
rebate84424103reba_te_
rebater93517903reba_ter
rebates95123173reba_tes
rebooted11248463rebooted
rebutted11126783rebutted
recalled11310793recalled
recaned102817203reca_ned
recanter101913153recanter
recapped1535943recapped
recharted1557563recharted
recited104319103re_cited
recked134821803re__cked
recoated113416783recoated
recocked17248473recocked
recrated112918583recrated
recycled1634813recycled
redacting13612303redacting
redaction1259663redaction
redactors1247533redactors
redamaged1443343redamaged
redargued1242843redargued
redbaiter1244153redbaiter
redded94019543red__ded
reddened1136423reddened
reddled102912323red_dled
redecide12127183redecide
redecided1455123redecided
reded74829113red___ed
redeemed1235593redeemed
redefected1743853redefected
redefied1368223redefied
redenied10511283redenied
redialed10310793redialed
redialled1145883redialled
redictated1447483redictated
redipped1434783redipped
redirected1444773redirected
redlined103811233redlined
rednecked1743163rednecked
redonned10297103redonned
redried93714893red_ried
redubbed1433143redubbed
reduce9713253reduc_e_
reducer1059003reduc_er
reduces10513343reduc_es
reductor1156433reductor
redyed114611233red__yed
reearned948883reearned
reedited10310083reedited
reeducated1484823reeducated
reejected1955093reejected
reelected1238313reelected
reerected1238613reerected
reested82916233re_ested
reface113616353refac_e_
refaces123216743refac_es
refasten1136103refasten
refitted12309413refitted
reflated123514293reflated
reflected1547983reflected
refuted114313803re_futed
regained102111243regained
regaled93615953rega_led
regarded11279803regarded
regauged1135143regauged
regrafted1435243regrafted
regranted1137703regranted
regrated102816323regrated
rehabbed1663713rehabbed
rehanged1357833rehanged
rehashed1536063rehashed
reheated122415003reheated
reincited1246853reincited
reindicted1485043reindicted
reinducted1464413reinducted
rejacket2166733rejacket
rejacketed2442273rejacketed
rejectee17289623rejectee
rejecter17258943rejecter
relace83122153relac_e_
relaces93420883relac_es
relanded102410463relanded
relapsed1136523relapsed
relate64033633rela_te_
relater73723143rela_ter
relates73731423rela_tes
relaxed153312523rela_xed
relayed113212753rela_yed
relented92614943relented
relisted9312623relisted
relocated12710813relocated
relocked15217743relocked
remailed112411403remailed
remained112412893remained
remanded123011323remanded
remanned11319353remanned
remapped1534913remapped
remarked15209243remarked
remaster10311473remaster
rematched1745223rematched
remate84428683rema_te_
remates93827103rema_tes
remelted11310153remelted
reminted113615083reminted
remitted113312073remitted
renailed92512803renailed
renamed103114523rena_med
renested92212953renested
rented74426593re__nted
repainted1277863repainted
repaired1148953repaired
reparked15208923reparked
repartee10312753repartee
repassed11229273repassed
repatched1745313repatched
repaved133311133repa_ved
repeated113117443repeated
repented112614983repented
replaced133211393replac_ed
replanted1248063replanted
replated112817513replated
reported11312703reported
repotted1139283repotted
reputed104613483re_puted
requited18169723requited
reraised9312353reraised
rerented92516163rerented
rerouted9311143rerouted
resailed93613063resailed
resaluted1046473resaluted
resawed113111183resa_wed
rescaled113311303rescaled
rescued10410043re_scued
reseated93220263reseated
resented92716963resented
resifted12310153resifted
resisted9312693resisted
resited85122423re_sited
reslated93517523reslated
resorted9313493resorted
respaced1338503respac_ed
respected1438493respected
respited11410813respited
restacked1636483restacked
restarted10410053restarted
restated93120173restated
rested74430783re__sted
resulted939713resulted
retackled1644073retackled
retagged1136063retagged
retailed94113963retailed
retained93016093retained
retaped103814283reta_ped
retarded102410753retarded
retaste72313133retaste_
retastes82212903retastes
retaxed153512233reta_xed
retched133814273re_tched
retested92212533retested
retinted94414363retinted
retorted9312333retorted
retraced111413023retrac_ed
retracked1657453retracked
retroacted1366133retroacted
retted74826313re__tted
reunited939713reunited
revalued1237023revalued
revamped1634143revamped
reverted122714713reverted
revested122612243revested
revetted122210943revetted
revolted12319863revolted
revoted114314153re_voted
rewaked153811903rewa_ked
rewarded13229523rewarded
rewarmed14257433rewarmed
rewashed1546243rewashed
rewaxed18409343rewa_xed
rewetted12228353rewetted
roached133211833r_oached
roasted83912663r_oasted
rotated82715293rota_ted
seated75131053se_a_ted
sedate73019803seda_te_
sedater83713623seda_ter
sedates83418033seda_tes
seduced1186753seduc_ed
selected1159783selected
teated74924023te_a_ted
tenanted937043tenanted
treated83618703tre_a_ted
unacted10312733_unacted
undated93118463unda_ted
updarted1244313updarted
updated11369423upda_ted
yeasted1138503ye_asted

Search took 9 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.190940478.9
2DLD Change Limit1461623648.25017716.6
3Display Results3643640.1402600.0
 (SQL Overall)1786913648.58020826.5
 
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.