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

215 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
retinals8561296(None) 
retinal75318351retinal_
retinas74819351retina_s
retinols8419741retinols
fetials103711742feti_als
meticals12310762meticals
rationals949942rationals
recitals1039762recitals
redials84416882redi_als
reginal84814292reginal_
reginas85614062regina_s
regionals10286412regionals
retial64724992reti_al_
retina65023382retina__
retinae75517332retina_e
retines75134672retin_es
retinol7469692retinol_
retints74717012retin_ts
retinues85113152retinues
retinula845722retinula
retinulas945362retinulas
retotals838462retotals
retrials8510822retrials
retsinas8387962retsina_s
revisals1136812revisals
revivals1435432revivals
actinal9312293actinal_
aerials74017553aeri_als
cretinous1145893cretinous
cretins93216423cretin__s
criminals1346293criminals
decimals1345863decimals
denials84114133deni_als
dentinal939503dentinal_
detinues9569823detinues
devisals1245613devisals
epinaos936283_epinaos
eternals8238953_eternals
ethicals1345533_ethicals
ethinyls1442873_ethinyls
etnas54713933_et_na_s
fecials123510333feci_als
festivals1543373festivals
fetial95716193feti_al_
fetiales11319613feti_ales
fetialis11358663feti_alis
finals94316163__finals
geminal10109903geminal_
genitals937243genitals
gremials1136133gremi_als
laminals10339303laminals
latinas74416463latina_s
lethals1038113let_hals
matinal9312603matinal_
medials103914733medi_als
medicals1349363medicals
medinas103411463medina_s
menials94015683meni_als
metals84520883met__als
meticais1248183meticais
metical11315363metical_
nationals948863nationals
nitinols844413nitinols
nominals10278613nominals
optionals1145343optionals
ordinals946753ordinals
originals1044843originals
patinas96318523patina_s
petals84719813pet__als
petnaps1145033pet_naps
presignals1363843presignals
pretrials1158143pretrials
radials83614633radi_als
radicals112610153radicals
ratals64219583rat__als
ratines75328583ratin_es
ratings84217413ratin_gs
rational8412543rational_
rationale949463rationale
rationales1049313rationales
reals55038653re___als
rebills93510623rebi_lls
rebinds104511873rebin_ds
recital9412163recital_
recoals94214623re_coals
recusals1056393recusals
redial74923113redi_al_
redias74523603redi_a_s
refills103711423refi_lls
refinable1438623refinable
refinds114512123refin_ds
refiners114713313refiners
refines105426343refin_es
refusals1164913refusals
refutals1165503refutals
regina75317143regina__
reginae84713453regina_e
regional9438783regional_
regnal74812933re_gnal_
rehinges1248403rehinges
reinks105012153re_in_ks
reins56234563re_in__s
rekindle1344643rekindle
rekindles1443863rekindles
relines75331323relin_es
relinks114510223relin_ks
reminds104614793remin_ds
remints95117293remin_ts
remittals1144883remittals
removals1345643removals
renails74917263re__nails
renal55929503re__nal_
renewals1137273renewals
renins64526453renin__s
rentals74017473re_ntals
reoils64516873reoi__ls
repanels1036783repanels
repeals94014523re_peals
repiners103913433repiners
repines94927383repin_es
repins84924313repin__s
reposals1037403reposals
reprisals1144563reprisals
requitals1844043requitals
reseals73917663re_seals
residuals10223803residuals
resinate8316773resinate
resinates9314763resinates
resinous838503resinous
resins64528773resin__s
restorals978073restorals
retags73414303ret__ags
retails74718973ret_ails
retainers92510763retainers
retains74522253retain__s
reteams9339563ret_eams
retears72814923ret_ears
retells73211523ret_ells
retenes76324623reten_es
rethinks1576033rethin_ks
retia55326113reti_a__
retiary1038333reti_ary
reticle94112623reti_cle
reticles103912483reticles
reticula1047413reticula
reticule1049303reticule
reticules1139013reticules
reties65436193reti__es
retile65929673reti__le
retiles74426993reti_les
retimes95020173reti_mes
retinacula1252103retinacula
retine66237333retin__e
retinene839803retinene
retinenes9410373retinenes
retinite8314853retinite
retinites9313503retinites
retinitis948023retinitis
retinoid947353retinoid
retinoids1045383retinoids
retint65633443retin__t
retinted94414363retinted
retinue75414843retin_ue
retinued95210823retinued
retinulae945363retinulae
retinular944763retinular
retirant8313593retirant
retirants947323retirants
retirees84611653retirees
retirers84311533retirers
retires74726213reti_res
retitle73913093reti_tle
retitles83612593retitles
retools73411023ret_ools
retotal739843retotal_
retral64419743ret_ral_
retreads937823retreads
retreats8311413retreats
retrial7615553retrial_
retrievals1342623retrievals
retsina74710603retsina__
retunes76918403retun_es
reveals103812723re_veals
reviewals1542963reviewals
revisal1038263revisal_
revival1337033revival_
rewinds114810483rewin_ds
rewins95020823rewin__s
rexines144719153rexin_es
rhinal9510193r_hinal_
rials55026673r__i_als
rituals738353rit_uals
rivals94213183r__ivals
riyals94111083r__iyals
rosinols845673rosinols
ruminal9289993ruminal_
rusticals1145353rusticals
rutins63818393rutin__s
seconals1047053seconals
sectionals1247273sectionals
seminal91213403seminal_
seminars1079043seminars
sentinels947423sentinels
serials73919743seri_als
sestinas8249133sestina_s
spinals93911863_spinals
terminals1147453terminals
tertials8510073terti_als
tetanal738023tetanal_
ticals83214713__ticals
tincals93610643__tincals
urinals7610253_urinals
veinal93812963ve_inal_
verticals1457243verticals
vinals94716483__vinals

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622157.67019056.3
3Display Results2152150.0962239.6
 (SQL Overall)1786912157.92222556.3
 
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.