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

330 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
retinae7551733(None) 
reginae84713451reginae
retina65023381retina_
retinal75318351retinal
retinas74819351retinas
retine66237331retin_e
retinue75414841retinue
detinue85010032detinue
patinae95414402patinae
ratine65131822ratin_e
rediae74221992redi_ae
refine95225692refin_e
regina75317142regina_
reginal84814292reginal
reginas85614062reginas
rehinge1148502rehinge
reline65434352relin_e
repine85627812repin_e
resinate8316772resinate
retene69224272reten_e
retia55326112reti_a_
retial64724992reti_al
reticle94112622reticle
retie55735302reti__e
retile65929672reti_le
retime85321802reti_me
retinals85612962retinals
retinene839802retinene
retines75134672retines
retinite8314852retinite
retinol7469692retinol
retint65633442retin_t
retinted94414362retinted
retints74717012retints
retinued95210822retinued
retinues85113152retinues
retinulae945362retinulae
retire64927012reti_re
retiree75019082retiree
retitle73913092retitle
retsina74710602retsina_
retsinas8387962retsinas
retune69121952retun_e
rexine134719442rexin_e
actinal9312293actinal
actiniae101810013actiniae
aedine73218393aedin_e
betaine9413783betain_e
betide95115973beti_de
betime105914833beti_me
betise85616273beti_se
carinae94318583carinae
catenae9311363catenae
cetane8315283cetan_e
creatine103417413creatin_e
cretin82917913cretin__
cretins93216423cretin_s
cretonne1044363cretonne
define104718143defin_e
dentinal939503dentinal
dentine83320243dentin_e
destine83719953destin_e
detainee92511723detainee
detente83313603detente
detinues9569823detinues
detonate9311193detonate
emetine9712943emetin_e
ermine8416923ermin_e
ethane94613243_ethane
etna46415263_et_na_
etnas54713933_et_nas
evince1137763_evince
exine125518493_exin_e
feline94820143felin_e
feminie12179933feminie
feriae95618603feri_ae
ferine96422583ferin_e
festinate1249473festinate
fetial95716193feti_al
feting104417793fetin_g
geminal10109893geminal
geminate11411793geminate
gratine84719193gratin_e
gratinee93710783gratinee
heinie92512663he_inie
herniae1039043herniae
intimae9109743intimae
intine61021983intin_e
ketene106613003keten_e
ketone105014533keton_e
laminae93512973laminae
latina65621143latina_
latinas74416463latinas
matinal9312603matinal
matinee92415613matinee
mediae94217413medi_ae
medina94114093medina_
medinas103411463medinas
meinie82614523me_inie
methane123211793methane
metical11315363metical
meting94320593metin_g
metisse936503metisse
metopae1147743metopae
minae75627723__minae
mutine84420373mutin_e
patina86022193patina_
patinaed11407833patinaed
patinas96318523patinas
patinate103016313patinate
patine85328123patin_e
pectinate1349553pectinate
pennae84314033pe_nnae
perinea9313033perinea
petiole9311303petiole
petite84320653peti_te
petnap1037423pet_nap
prerinse1038633prerinse
pretence122312123pretence
pretense10199823pretense
rapine85023083rapin_e
ratines75328583ratines
rating74938703ratin_g
ratings84217403ratings
rational8412543rational
rationale949463rationale
ratite65022423rati_te
ratline74517803ratlin_e
ravine95522223ravin_e
rebind94416933rebin_d
rebinds104511873rebinds
recane83022873recan_e
recipe103414893reci_pe
recital9412163recital
recite83625113reci_te
reclinate11410023reclinate
recline94020493reclin_e
recoinage1245643recoinage
redia65524483redi_a_
redial74923113redi_al
redias74523603redi_as
reding83825563redin_g
redline84218833redlin_e
redone74820053redon_e
refence12312233refence
refile95122373refi_le
refinable1438623refinable
refinance14117643refinance
refind104717073refin_d
refinds114512123refinds
refined114720003refined
refiner105316913refiner
refines105426343refines
refire95419473refi_re
reggae858953re_ggae
regime95313943regi_me
regional9438783regional
regive104814323regi_ve
regna64614813re_gna_
regnal74812933re_gnal
rehinged1336853rehinged
rehinges1248403rehinges
rehire95415863rehi_re
reimage1037913re_image
rein46040893re_in__
reindex1536093re_index
reined74425523re_ined
reink95518093re_in_k
reinked1239793re_inked
reinks105012153re_inks
reins56234563re_in_s
reinter73116843re_inter
reinvade1244503re_invade
reive85522943re_i_ve
rekindle1344643rekindle
reliance10310473reliance
reliant7319243reliant
relieve105010693relieve
relined85321933relined
relines75331323relines
relink104415923relin_k
relinked1337003relinked
relinks114510223relinks
relique1636823relique
relive95120783reli_ve
remind94819793remin_d
reminded123411523reminded
reminder113110513reminder
reminds104614793reminds
remint85329973remin_t
reminted113615083reminted
remints95117293remints
remise84221953remi_se
renal55929503re__nal
rename82718813re__name
renin54830033renin__
renins64526453renin_s
rennase738713re_nnase
rente54733783re__nte
renting84026853rentin_g
repin75324703repin__
repined104918773repined
repiner94816903repiner
repines94927383repines
repinned1157473repinned
repins84924313repin_s
reptile93914083repti_le
rerise64325633reri_se
reshine102816943reshin_e
reside74224933resi_de
residue8689863residue
resile64627673resi_le
resin54131053resin__
resinated10413283resinated
resinates9314763resinates
resined84522653resined
resins64528773resin_s
resiny94617363resin_y
resite64128453resi_te
resize154117723resi_ze
resonate8513513resonate
resting85031183restin_g
restive10315933resti_ve
retable91820403retable
retag63618413ret__ag
retain64523283retain__
retained93016093retained
retainer82913813retainer
retains74522253retain_s
retake104718533ret_ake
retape83917683ret_ape
retaste72313133retaste
retax124517973ret__ax
rete44944133ret___e
reteam83214533ret_eam
retear63115483ret_ear
retenes76324623retenes
rethink1488883rethin_k
rethinker1643613rethinker
rethinks1576033rethinks
retiary1038333retiary
reticence1347623reticence
reticles103912483reticles
reticule1049303reticule
retied75924983reti_ed
reties65436193reti_es
retiled84420513retiled
retiles74426993retiles
retimed104714653retimed
retimes95020173retimes
retinenes9410373retinenes
retinites9313493retinites
retinoid947353retinoid
retinols8419743retinols
retinula845723retinula
retinular944763retinular
retinulas945363retinulas
retirant8313593retirant
retired84620143retired
retirees84611653retirees
retirer74715013retirer
retires74726213retires
retitled9339553retitled
retitles83612593retitles
retore67630763ret_ore
retotal739843retotal
retrace91417343retrace
retrainee9511163retrainee
retral64419743ret_ral
retread849003retread
retreat7317533retreat
retrial7615553retrial
retrieve1175693retrieve
retting83425883rettin_g
retuned86613973retuned
retunes76918403retunes
returnee8449883returnee
retuse66617223ret_use
retying113213833retyin_g
retype11399143ret_ype
reunite7312713reunite
revenge1138573revenge
revenue1039533revenue
revile94921613revi_le
revisal1038263revisal
revise94019743revi_se
revival1337033revival
revive124914823revi_ve
rewin85623963rewin__
rewind104715883rewin_d
rewinded13277673rewinded
rewinder12317663rewinder
rewinds114810483rewinds
rewins95020823rewin_s
rewire95421403rewi_re
rexines144719153rexines
rezone153814783rezon_e
rhinal9510183r_hinal
rinse54820973r__inse
routine72615903routin_e
ruinate7312833r_uinate
rumina83412483rumina_
ruminal9289993ruminal
ruminate10511473ruminate
rusine63916593rusin_e
rutile65217683ruti_le
rutin55421343rutin__
rutins63818393rutin_s
seine55732873se_in_e
semina8915563semina_
seminal91213403seminal
seminar979753seminar
serine65432673serin_e
sestina72711973sestina_
sestinas8249133sestinas
sestine73017923sestin_e
setae56026223set__ae
setline7313923setlin_e
teniae64517353teni_ae
tetanal738023tetanal
tine45855133__tin_e
tinea54923153__tinea
tinge64626613__tinge
urethane1145433urethane
urethrae1174283urethrae
vaginae11377683vaginae
veinal93812963ve_inal
venae85920983ve__nae
venine93718433venin_e
vesicae12177703vesicae

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273307.25018486.5
3Display Results3303300.1232682.9
 (SQL Overall)1786913307.52923733.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.