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

341 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
redacting1361230(None) 
reacting113317891re_acting
redating102620171reda_ting
deducting1436842deducting
enacting11311362_enacting
exacting1838522_exacting
preacting142412532pre_acting
predating13514652preda_ting
predicting1649872predicting
reaching143317202re_aching
readapting1445152readapting
rebaiting12311642rebaiting
rebating112418342reba_ting
recanting122414822recanting
recasting122414232recasting
redaction1259662redaction
redactions1359132redactions
redbaiting1446262redbaiting
redocking17126782redocking
redrafting1545962redrafting
reducing12310202reduc_ing
reenacting1357352reenacting
refacing142512812refac_ing
refecting152413352refecting
refracting1638732refracting
rejecting192211152rejecting
relacing112516042relac_ing
relating92725442rela_ting
relucting1239772relucting
remating112322422rema_ting
repacking1838282repacking
repasting122312842repasting
reracking1639312reracking
resecting122816482resecting
retacking1658972retacking
retasting102513412retasting
retracting13311932retracting
sedating103014112seda_ting
abducting1584083abducting
abreacting1544533abre_acting
acting95920983___acting
adapting1236643_adapting
addicting1485073addicting
adducting1494303adducting
aerating92821003aera_ting
beaching164114143be_aching
beating104326873be_a_ting
bedamning1534183bedamning
bedaubing1553193bedaubing
bedecking1934283bedecking
berating113220763bera_ting
breaching17269403bre_aching
breasting1239583bre_asting
coacting133412703_coacting
coenacting1545873coenacting
creating113921953cre_a_ting
crediting1338843cred_iting
cremating14312203crema_ting
darting94020663__darting
dating85326483__da_ting
dauting93814763__dauting
dawting123610673__dawting
debating123213733deba_ting
decanting132510633decanting
decocting1538123decocting
dedicating1539143dedicating
deducing1336423deduc_ing
defacing15238683defac_ing
defatting1436103defatting
defecting162510223defecting
dejecting20217793dejecting
delating103119603dela_ting
demasting1338453demasting
departing1349513departing
depicting1537813depicting
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
detaching1637263detaching
detecting13259983detecting
detracting1438713detracting
ducting113713593__ducting
easting84924303_e_asting
eating75134403_e_a_ting
editing9313133_ed_iting
educating1337933_educating
educing1137683_educ_ing
ejecting18268163_ejecting
elating83423083_ela_ting
electing112113783_electing
erecting112415063_erecting
eructing112110173_eructing
evicting1437483_evicting
exalting1638033_exalting
feasting122011323fe_asting
foredating1577123foreda_ting
gelating103015733gela_ting
gradating1237323grada_ting
hearting12513123he_arting
heating114024323he_a_ting
ideating10311703idea_ting
impacting1635943impacting
indicting1339613indicting
inducting1338373inducting
iodating1038823ioda_ting
leaching143012833le_aching
legating102313113lega_ting
levanting1345523levanting
medaling121912263meda_ling
medalling1346923medalling
mediating13311203mediating
medicating1648953medicating
menacing1339783menac_ing
misacting1439083misacting
negating102012833nega_ting
nidating1039783nida_ting
nonacting1238783nonacting
outacting1239213outacting
overacting16310913overacting
peaching163613643pe_aching
peacing124117073pe_ac_ing
pedaling122412133peda_ling
pedalling1346663pedalling
preaching172811163pre_aching
preadapting1743653preadapting
precasting15169833precasting
predicating1749653predicating
preenacting16125373preenacting
prefacing17118743prefac_ing
prelecting15310163prelecting
prepacking2145773prepacking
prepasting15168883prepasting
pretasting13239283pretasting
racing95030533r__ac_ing
racking144323663r__acking
radiating111112133radiating
radicating1459073radicating
rafting113815753r__afting
ranting84025413r__anting
rating74938703r__a_ting
ratting83822363r__atting
reactant10311433re_actant
reaction10612603re_action
reactions11711713re_actions
reactive13310473re_active
readdicting1643813readdicting
readding11411363re_adding
reading93327213re_a_ding
readopting1465513readopting
readying13410223re_adying
reaming103924013re_a_ming
reaping103621213re_a_ping
rearing83128783re_a_ring
rearming111413613re_arming
reaving113820533re_a_ving
rebooting12139023rebooting
rebutting1237523rebutting
recalling122211903recalling
recaning111416693reca_ning
recapping1636453recapping
recharting1637213recharting
reciting113118073re_citing
recking144319923re__cking
recoating121317463recoating
recocking18138373recocking
recrating121318793recrating
recutting1239483recutting
recycling1734903recycling
redact9419043redact___
redacted12410243redact_ed
redactional1454353redactional
redactor1147023redact_or
redactors1247533redactors
redacts10510943redact__s
redamaging1543763redamaging
redarguing1342863redarguing
reddening1237433reddening
redding103218513red__ding
reddling112911813red_dling
redeciding1544703redeciding
redeeming1337363redeeming
redefecting1844373redefecting
redefying1736093redefying
redenying1437783redenying
redialing11311843redialing
redialling1246203redialling
redictating1546803redictating
reding83825563red___ing
redipping1555593redipping
redirecting1545613redirecting
redlining111210293redlining
redoing93516733red__oing
redonning11127643redonning
redrawing1437213redrawing
redriving1437603redriving
redrying13209023red_rying
redubbing1543573redubbing
reductant1246753reductant
reduction1259903reduction
reductions1359583reductions
reductive1547793reductive
redwing122811983red__wing
redyeing1336173red_yeing
reearning1039053reearning
reediting11310953reediting
reeducating1545163reeducating
reejecting2045813reejecting
reelecting1338783reelecting
reerecting1339973reerecting
reesting93118273re_esting
refalling132010423refalling
refitting132811123refitting
reflating132514713reflating
reflecting1638823reflecting
refuting121911903re_futing
regaining112411083regaining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regrating
rehabbing1733653rehabbing
rehanging1437563rehanging
rehashing1647113rehashing
reheating132314913reheating
reinciting1347103reinciting
reindicting1545073reindicting
reinducting1544383reinducting
rejacketing2542413rejacketing
relanding112110923relanding
relapsing1236843relapsing
relaxing162612633rela_xing
relaying122515153rela_ying
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
relocating13310873relocating
relocking16137683relocking
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
rematching1844913rematching
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remitting122412623remitting
renailing102813333renailing
renaming11313693rena_ming
renesting102514703renesting
renting84026853re__nting
repainting13128973repainting
repairing12310013repairing
reparking1638923reparking
repassing12249423repassing
repatching1844993repatching
repaving142810743repa_ving
repaying142712393repa_ying
repeating122618983repeating
repenting122316553repenting
replacing142210163replac_ing
replanting1338523replanting
replating122217403replating
reporting12513903reporting
repotting12511123repotting
reputing112412603re_puting
requiting1939883requiting
reraising10313773reraising
rerenting102617663rerenting
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433resa_wing
resaying122512453resa_ying
rescaling122212013rescaling
rescuing1139623re_scuing
reseating102421533reseating
resenting102619293resenting
resetting102816293resetting
resifting133512093resifting
resisting103215313resisting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resorting10614613resorting
respacing1438893respac_ing
respecting1549883respecting
respiting121912863respiting
restacking1737183restacking
restarting11310663restarting
restating102319413restating
resting85031183re__sting
resulting10311083resulting
retackling1744433retackling
retagging1236033retagging
retailing103214733retailing
retaining102114733retaining
retaking133114283reta_king
retaping113012553reta_ping
retarding111110653retarding
retaxing162311333reta_xing
retching143412173re_tching
reteaching1636023reteaching
retesting102614603retesting
retinting102215253retinting
retorting10613273retorting
retracing12313293retrac_ing
retracking1738163retracking
retroacting1447283retroacting
retting83425883re__tting
reuniting10310693reuniting
revaluing1337303revaluing
revamping1734633revamping
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
revolting1339633revolting
revoting12312033re_voting
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewashing1676903rewashing
rewaxing19248563rewa_xing
rewetting132710443rewetting
rewriting13310413rewriting
roaching143210433r_oaching
roasting93012703r_oasting
rotating92614553rota_ting
seating84130683se_a_ting
seducing1236503seduc_ing
selecting12310533selecting
teaching143612603te_aching
tenanting1036213tenanting
treating92519613tre_a_ting
updarting1334333updarting
updating1236593upda_ting
yeasting12188923ye_asting

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.423422437.4
2DLD Change Limit1486413417.03021143.8
3Display Results3413410.1562185.9
 (SQL Overall)1786913417.60923484.2
 
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.