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

454 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
retained9301609(None) 
detained103111641detained
regained102111241regained
remained112412891remained
retailed94113961retailed
retainer82913811retainer
retrained10411311retrained
attained997352attained
betaine9413782betaine_
betaines10313292betaines
destained1158252destained
detailed10319872detailed
detainee92511722detainee
detainer92910792detainer
detrained1158912detrained
obtained1136532obtained
pertained1238492pertained
pretrained1357062pretrained
rained75024602r__ained
reattained1144582reattained
rebaited11410542rebaited
recaned102817202reca_ned
reclined113613602reclined
recoined113614422recoined
redlined103811232redlined
reearned948882reearned
refined114720002re_fined
refrained1347222refrained
regainer9249352regainer
reined74425522re__ined
rejoined16318592rejoined
relined85321932re_lined
remailed112411402remailed
remanned11319352remanned
renailed92512802renailed
reobtained1343392reobtained
repainted1277862repainted
repaired1148952repaired
repined104918772re_pined
reraised9312352reraised
resailed93613062resailed
reshined123011122reshined
resined84522652re_sined
restrained1148412restrained
retacked15169272retacked
retagged1136062retagged
retailer82911572retailer
retain64523282retain__
retainers92510762retainers
retains74522252retain_s
retaped103814282reta_ped
retarded102410752retarded
retasted92412112retasted
retaxed153512232reta_xed
retied75924982ret_i_ed
retiled84420512ret_iled
retimed104714652ret_imed
retine66237332ret_ine_
retines75134672ret_ines
retinted94414362ret_inted
retinued95210822ret_inued
retired84620142ret_ired
retrainee9511162retrainee
retried84419152retri_ed
retuned86613972ret_uned
returned9459132returned
stained84215342_stained
abstained1245053abstained
attainer8116913attainer
attainted1044693attainted
beaned95621473be_a_ned
bedamned1434583bedamned
beelined11277713beelined
bepainted1484343bepainted
betaxed17307023beta_xed
betided114810203bet_ided
bewailed1435343bewailed
brained103816103_brained
captained1446193captained
certainer1146193certainer
cetane8315283ceta_ne_
cetanes9315133ceta_nes
chained133812693_chained
contained12310893contained
creatine103417413creatine_
creatines112814433creatines
curtained1265503curtained
deaired9411533de_aired
deaned84620453de_a_ned
declined123910883declined
defined123813823de_fined
delaine8314783delaine_
delaines9312943delaines
depainted1375843depainted
deraigned1244093deraigned
derailed102410403derailed
destined103312453destined
detached1537733detached
detailer9268673detailer
detain74617383detain__
detainees10267153detainees
detainers10269103detainers
detains83716093detain_s
deveined1336673deveined
distained1139603distained
drained93713253_drained
earned74818333_e_arned
eloined8149813_eloined
emailed10359213_emailed
engined9119893_engined
entailed989523entailed
entrained1089413entrained
entwined1235843entwined
ermined10410603_ermined
etamine91313073_etamine_
etamines101611803_etamines
examined18135863_examined
gained84617463__gained
grained93814273_grained
greatened1144583greatened
intwined1235463intwined
jeaned143813463je_a_ned
jetliner1534853jetliner
jettied15366973jetti_ed
ketamine14157053ketamine_
ketamines15177023ketamines
leaned73422543le_a_ned
learned8329303le_arned
metaled102913873meta_led
metalised12310463metalised
metalized21412183metalized
metalled1148973metalled
mutined103311353mut_ined
neatened937043neatened
obtainer1045793obtainer
ordained1035173ordained
outgained1137223outgained
outlined92512953outlined
pained95622853__pained
patined105114783pat_ined
peined94918843pe__ined
petaled103614143peta_led
petaline10314883petaline_
petalled1138693petalled
plained103812233_plained
preobtained1652763preobtained
pretaped13339133preta_ped
pretasted12147963pretasted
prettied1159253pretti_ed
prevailed1536043prevailed
prewarned1594773prewarned
raided85017703r__aided
railed74727543r__ailed
raised76120333r__aised
ratanies8312923ratanies
ratine65131823rat_ine_
ratines75328583rat_ines
rationed9410093rationed
ratline74517803ratline_
ratlines83815293ratlines
ratooned977103ratooned
rattailed1084213rattailed
rattened9218623rattened
ravined115411823r_avined
reached134619083re_ached
reacted103015713re_acted
readded103310733re_added
readied93316623re_adied
realigned1145333realigned
realised92214533realised
realized182514223realized
reamed94326123re_a_med
reannex1434733re_annex
reaped94122453re_a_ped
reared75930013re_a_red
rearmed103912823re_armed
reasoned9410733reasoned
reavailed1344003reavailed
reaved104523923re_a_ved
rebated103619693reba_ted
rebind94416933re_bin_d
reboiled11349393reboiled
recalled11310803recalled
recane83022873reca_ne_
recanes93222263reca_nes
recanted112513513recanted
recapped1535943recapped
received1437983received
recited104319103re_cited
reckoned1546953reckoned
reclaimed1435543reclaimed
recline94020493recline_
recliner103211913recliner
reclines103718543reclines
recoiled113613213recoiled
reconned113610653reconned
redacted12410243redacted
redated93120923reda_ted
redbaited1344713redbaited
reddened1136423reddened
redefined1445593redefined
redenied10511283redenied
redialed10310793redialed
redline84218833redline_
redliner93510473redliner
redlines93916083redlines
redonned10297103redonned
redried93714893redri_ed
reedited10310083reedited
reexamined2052893reexamined
refaced133713573refa_ced
refiled114318653re_filed
refind104717073re_fin_d
refine95225693re_fine_
refiner105316913re_finer
refines105426343re_fines
refired115116993re_fired
refixed183611153re_fixed
refrainer1245843refrainer
refried113513873refri_ed
regain74517763regain__
regainers10237383regainers
regains84316583regain_s
regaled93615953rega_led
regarded11279803regarded
regauged1135143regauged
regrind938983regrin_d
rehabbed1663713rehabbed
rehanged1357833rehanged
rehashed1536063rehashed
rehinged1336853re_hinged
rehired115013153re_hired
reified112913783reifi_ed
reigned949213re_igned
reimagined1442893reimagined
reinked1239793re__inked
reived104518133re__ived
rejoiced18296923rejoiced
relaced103517213rela_ced
relaid75518443relai__d
reland75920433rela_n_d
relanded102410463relanded
relapsed1136523relapsed
related83327573rela_ted
relaxed153312523rela_xed
relayed113212753rela_yed
relearned1035633relearned
relied74926233re_li_ed
reline65434353re_line_
relines75331323re_lines
relinked1337003re_linked
relived115114683re_lived
reloaned939723reloaned
relumined1245363relumined
remain85919863remain__
remainder1244683remainder
remains94117893remain_s
remand95618963rema_n_d
remanded123011323remanded
remapped1534913remapped
remarked15209243remarked
remated103522473rema_ted
remind94819793re_min_d
reminded123411523re_minded
reminted113615083re_minted
remised103516843re_mised
remixed173510743re_mixed
renamed103114523rena_med
renowned1235973renowned
reoiled84316853re_oiled
reopened1138503reopened
reordained1243443reordained
repacked17188743repacked
repaid94716323repai__d
repaint9318363repain_t
repaints1038483repaints
repairer1036783repairer
repand95316063repa_n_d
repanel939963repa_nel
reparked15208923reparked
repassed11229273repassed
repasted112611533repasted
repaved133311133repa_ved
repine85627813re_pine_
repiner94816903re_piner
repines94927383re_pines
repinned1157473repinned
replanned1235163replanned
replied103914443repli_ed
repriced132610543repriced
reprinted1289043reprinted
reprised112012203reprised
repugned1235353repugned
required18156833required
requited18169723requited
reracked15169123reracked
reraise7316313reraise_
reraises8415633reraises
resaid74517083resai__d
resawed113111183resa_wed
rescind10410393rescin_d
rescinded1335763rescinded
reseized1839213reseized
reshine102816943reshine_
reshines112615443reshines
resided95217703re_sided
resigned1038863resigned
resiled84621983re_siled
resited85122423re_sited
resized174614903re_sized
respired1148993respired
respited11410813respited
restabled12148953restabled
restacked1636483restacked
restaffed1653743restaffed
restaged103011853resta_ged
restamped1444433restamped
restarted10410053restarted
restated93120173resta_ted
restationed1244373restationed
restrainer1046973restrainer
retable91820403retable_
retables101712673retables
retackled1644073retackled
retail65522073retai__l
retailers9258773retailers
retailor8285223retailor
retailored1152953retailored
retails74718973retai_ls
retaining102114733retaining
retake104718533reta_ke_
retaken113911803reta_ken
retaker113714313reta_ker
retakes113718863reta_kes
retaking133114273retakin_g
retaliated1148433retaliated
retallied1046783retallied
retape83917683reta_pe_
retapes93917423reta_pes
retaping113012553retapin_g
retard75018933reta__rd
retarder9229433retarder
retarget9312743retarget
retaste72313133retaste_
retastes82212903retastes
retaxes143615093reta_xes
retaxing162311333retaxin_g
retched133814273ret_ched
reteamed1138013reteamed
retene69224273ret_ene_
retenes76324623ret_enes
retested92212533retested
rethink1488883rethin_k
rethinker1643613rethinker
rethinks1576033rethinks
retie55735303ret_i_e_
reties65436193ret_i_es
retile65929673ret_ile_
retiles74426993ret_iles
retime85321803ret_ime_
retimes95020173ret_imes
retina65023383ret_in_a
retinae75517333ret_inae
retinal75318353ret_inal
retinas74819353ret_inas
retinene839803ret_inene
retinoid947353ret_inoid
retinol7469693ret_inol
retint65633443ret_in_t
retints74717013ret_ints
retinue75414843ret_inue
retinues85113153ret_inues
retire64927013ret_ire_
retiree75019083ret_iree
retirer74715013ret_irer
retires74726213ret_ires
retitled9339553retitled
retooled938473retooled
retorted9312333retorted
retraced111413023retraced
retracked1657453retracked
retracted12410953retracted
retrain7615423retrain__
retrainees1046393retrainees
retrains8314523retrain_s
retries74129073retri_es
retrieved1385093retrieved
retrimmed1443673retrimmed
retsina74710603retsin_a
retsinas8387963retsinas
retted74826313ret__ted
retting83425883rettin_g
retune69121953ret_une_
retunes76918403ret_unes
returnee8449883returnee
returner8397983returner
retwisted1344893retwisted
retying113213833retyin_g
retyped13367303ret_yped
reunited939713reunited
revalued1237023revalued
revamped1634143revamped
reviled114417923re_viled
revised113815483re_vised
revived144211653re_vived
revoiced14317873revoiced
rewaked153811903rewa_ked
rewakened1743443rewakened
rewarded13229523rewarded
rewarmed14257433rewarmed
rewashed1546243rewashed
rewaxed18409343rewa_xed
rewind104715883re_win_d
rewinded13277673re_winded
rewired115413283re_wired
rexine134719443re_xine_
rexines144719153re_xines
rezoned173611163re_zoned
romaine9512123romaine_
romaines10512513romaines
rosined84911903r_osined
rotated82715293rota_ted
ruined74813323r__uined
sained75424243__sained
seined74023063se__ined
sequined18105653sequined
setline7313923setline_
setlines8312743setlines
sprained1138433sprained
stainer73614923_stainer
staned74824643_sta_ned
strained9412253strained
sustained1045373sustained
tailed74424663__tailed
tainted83512423__tainted
tanned75219953__tanned
tetanies8513543tetanies
tetanised1096513tetanised
tetanized1988443tetanized
tined65434533__t_ined
trained84117203_trained
trepanned1243913trepanned
trephined1544903trephined
trined74920713__trined
twined104413123__twined
unstained1038683unstained
untainted1038423untainted
untanned9279963untanned
untrained10510993untrained
untwined1237063untwined
veined104413913ve__ined
weaned103816153we_a_ned
yeaned103813903ye_a_ned
yearned11327373ye_arned

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.1561145455.1
2DLD Change Limit1461624548.33017546.5
3Display Results4544540.1862440.9
 (SQL Overall)1786914548.67220605.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.