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

338 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
retainer8291381(None) 
detainer92910791detainer
regainer9249351regainer
retailer82911571retailer
retained93016091retained
retainers92510761retainers
attainer8116912attainer
betaine9413782betaine_
betaines10313292betaines
certainer1146192certainer
detailer9268672detailer
detained103111642detained
detainee92511722detainee
detainers10269102detainers
jetliner1534852jetliner
obtainer1045792obtainer
recliner103211912recliner
redliner93510472redliner
refiner105316912re_finer
refrainer1245842refrainer
regained102111242regained
regainers10237382regainers
remainder1244682remainder
remained112412892remained
repairer1036782repairer
repiner94816902re_piner
restrainer1046972restrainer
retailed94113962retailed
retailers9258772retailers
retailor8285222retailor
retain64523282retain__
retains74522252retain_s
retaker113714312reta_ker
retarder9229432retarder
rethinker1643612rethinker
retine66237332ret_ine_
retines75134672ret_ines
retirer74715012ret_irer
retrained10411312retrained
retrainee9511162retrainee
returner8397982returner
stainer73614922_stainer
abstainer1144403abstainer
attainder10103393attainder
attained997353attained
attainers9115593attainers
betatter1035453betatter
bewailer1334863bewailer
cetane8315283ceta_ne_
cetanes9315133ceta_nes
container11311073container
creatine103417413creatine_
creatines112814433creatines
decliner113710843decliner
definer114413773de_finer
delaine8314783delaine_
delaines9312943delaines
destained1158253destained
detacher1437543detacher
detailed10319873detailed
detailers10257253detailers
detain74617383detain__
detainees10267153detainees
detains83716093detain_s
detrained1158913detrained
drainer83012843_drainer
earner63617223_e_arner
eloiner7149183_eloiner
entailer877833entailer
entrainer968583entrainer
etamine91313073_etamine_
etamines101611803_etamines
examiner17145463_examiner
fainer94717243__fainer
frettier1156593fretti_er
gainer74117493__gainer
grainer83714063_grainer
jetliners1644183jetliners
jettier14358693jetti_er
ketamine14157053ketamine_
ketamines15177023ketamines
leaner64022193le_a_ner
learner7319383le_arner
meaner84617843me_a_ner
meatier93214613meati_er
metamer1139613meta_mer
metier83517693met_i_er
netminder1242513netminder
nettier74211813netti_er
obtained1136533obtained
obtainers1144853obtainers
ordainer945203ordainer
outliner82412103outliner
peatier94017233peati_er
pertained1238493pertained
petaline10314883petaline_
pettier94213613petti_er
plainer93811983_plainer
pretrained1357063pretrained
prettier1069043pretti_er
prevailer1445153prevailer
raider74318743r__aider
railer64524933r__ailer
rained75024603r__ained
rainier71614253r__ainier
raiser66620103r__aiser
ratanies8312923ratanies
ratine65131823rat_ine_
ratines75328583rat_ines
ratline74517803ratline_
ratlines83815293ratlines
ratooner886993ratooner
rattener8238533rattener
rattier74015593ratti_er
reacher123718293re_acher
reader73628293re_a_der
readier83117423re_adier
realer63528593re_a_ler
realiser82512563realiser
realizer172412113realizer
realter73716313re_alter
reamer84325213re_a_mer
reannex1434733re_annex
reaper84223143re_a_per
rearer64928913re_a_rer
reasoner849343reasoner
reattained1144583reattained
reaver94524733re_a_ver
rebaited11410543rebaited
rebater93517903reba_ter
recaller1039313recaller
recamier1237603recamier
recane83022873reca_ne_
recaned102817203reca_ned
recanes93222263reca_nes
recanter101913153recanter
receiver1337413receiver
reciter94117263re_citer
reckoner1446063reckoner
reclaimer1344463reclaimer
recline94020493recline_
reclined113613603reclined
recliners11279113recliners
reclines103718543reclines
recoiler103210493recoiler
recoined113614423recoined
redbaiter1244153redbaiter
redline84218833redline_
redlined103811233redlined
redliners10267853redliners
redlines93916083redlines
reearned948883reearned
reedier83815303reedi_er
reefier102912553reefi_er
reekier113111123reeki_er
refine95225693re_fine_
refined114720003re_fined
refiners114713313re_finers
refinery14447193re_finery
refines105426343re_fines
refrained1347223refrained
refrainers1344473refrainers
regain74517763regain__
regains84316583regain_s
regaler83814623rega_ler
regather1236733regather
rehabber1563153rehabber
rehammer1544653rehammer
reifier103414523reifi_er
reined74425523re__ined
reinter73116843re__inter
reiver95318293re__iver
rejoicer17315343rejoicer
rejoinder1743713rejoinder
rejoined16318593rejoined
relapser1035273relapser
relater73723143rela_ter
relaunder1053703relaunder
relaxer143410223rela_xer
relier65826183re_li_er
reline65434353re_line_
relined85321933re_lined
relines75331323re_lines
remailed112411403remailed
remain85919863remain__
remainders1354023remainders
remains94117893remain_s
remaker133813173rema_ker
remanned11319353remanned
remarker14178493remarker
remaster10311473remaster
reminder113110513re_minder
renailed92512803renailed
rentier73618223renti_er
reobtained1343393reobtained
repaint9318363repain_t
repainted1277863repainted
repaints1038483repaints
repair84011463repai__r
repaired1148953repaired
repairers1135283repairers
repanel939963repa_nel
repaper11310023repa_per
repine85627813re_pine_
repined104918773re_pined
repiners103913433re_piners
repines94927383re_pines
replier94214973repli_er
reprinter1197353reprinter
requirer17156113requirer
requiter17168643requiter
reraise7316313reraise_
reraised9312353reraised
reraises8415633reraises
resailed93613063resailed
rescinder1245293rescinder
reshine102816943reshine_
reshined123011123reshined
reshines112615443reshines
resider84615803re_sider
resigner937793resigner
resined84522653re_sined
restrained1148413restrained
restrainers1145123restrainers
retable91820403retable_
retables101712673retables
retacked15169273retacked
retagged1136063retagged
retail65522073retai__l
retailors9285343retailors
retails74718973retai_ls
retaining102114733retaining
retake104718533reta_ke_
retaken113911803reta_ken
retakers123511133reta_kers
retakes113718863reta_kes
retaking133114273retakin_g
retape83917683reta_pe_
retaped103814283reta_ped
retapes93917423reta_pes
retaping113012553retapin_g
retarded102410753retarded
retarders10227573retarders
retarget9312743retarget
retaste72313133retaste_
retasted92412113retasted
retastes82212903retastes
retaxed153512233reta_xed
retaxes143615093reta_xes
retaxing162311333retaxin_g
retemper1235183retemper
retene69224273ret_ene_
retenes76324623ret_enes
rethink1488883rethin_k
rethinkers1743023rethinkers
rethinks1576033rethinks
retie55735303ret_i_e_
retied75924983ret_i_ed
reties65436193ret_i_es
retile65929673ret_ile_
retiled84420513ret_iled
retiles74426993ret_iles
retime85321803ret_ime_
retimed104714653ret_imed
retimes95020173ret_imes
retina65023383ret_in_a
retinae75517333ret_inae
retinal75318353ret_inal
retinas74819353ret_inas
retinene839803ret_inene
retinol7469693ret_inol
retint65633443ret_in_t
retinted94414363ret_inted
retints74717013ret_ints
retinue75414843ret_inue
retinued95210823ret_inued
retinues85113153ret_inues
retire64927013ret_ire_
retired84620143ret_ired
retiree75019083ret_iree
retirers84311533ret_irers
retires74726213ret_ires
retorter8410733retorter
retracer101411883retracer
retrain7615423retrain__
retrainees1046393retrainees
retrains8314523retrain_s
retried84419153retri_ed
retries74129073retri_es
retriever1284213retriever
retsina74710603retsin_a
retsinas8387963retsinas
retting83425883rettin_g
retune69121953ret_une_
retuned86613973ret_uned
retunes76918403ret_unes
returned9459133returned
returnee8449883returnee
returners9376553returners
retying113213833retyin_g
reuniter838323reuniter
revamper1533533revamper
reviler104314973re_viler
reviser104114663re_viser
reviver134411373re_viver
rewarder12208233rewarder
rewinder12317663re_winder
rewriter1137923rewriter
rexine134719443re_xine_
rexines144719153re_xines
ritzier16297203ritzi_er
romaine9512123romaine_
romaines10512513romaines
rotifer1036993rot_ifer
rottener8216973rottener
ruiner64013643r__uiner
ruttier73412283rutti_er
seiner64622483se__iner
semainier1144753semainier
setline7313923setline_
setlines8312743setlines
staider83912613_staider
stained84215343_stained
stainers83212173_stainers
strainer8512213strainer
sustainer944783sustainer
tailer63823733__tailer
tanner63722283__tanner
tetanies8513543tetanies
trainer73316793_trainer
trepanner1143523trepanner
twiner94012593__twiner
vainer93714573__vainer
veiner94514753ve__iner
vetiver1336103vet_iver
weaner93816773we_a_ner
weiner94214133we__iner
yearner10336873ye_arner

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623388.75016704.2
3Display Results3383380.1232748.0
 (SQL Overall)1786913389.02919790.8
 
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.