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

254 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
petrales1031298(None) 
petrale9312621petrale_
fetiales11319612fetiales
peerages1189892peerages
percales12313802percales
petaled103614152pet_aled
petals84719812pet_al_s
petioles10311642petioles
petrels9279372petrel_s
petrols92913082petrol_s
pettles93916482pet_tles
peytrals1355492peytral_s
retraces101417272retraces
aerates74627493ae_rates
apetalies1148003apet_alies
astrals75515243astral_s
australes9317763australes
bedrapes1386963bedrapes
berakes134815773be_rakes
berates94126873be_rates
betakes134212523bet_akes
betrayed1436303betrayed
betrayer1345643betrayer
betrayers1445013betrayers
betrays12127823betra_ys
centraler1146683centraler
centralest1247143centralest
centrals102712033central_s
cerates95428253ce_rates
cetanes9315133cet_anes
chorales133712883chorales
citrals91111673citral_s
citrates102315093citrates
degrades11269923degrades
depraves1436873depraves
derates84028893de_rates
detracts11138833detracts
detrains9411763detrains
detrudes1036203detrudes
empales112411433_empales
enrages83114853_enrages
erases64425403_e_rases
etapes85415293_et_apes
ethanes103713513_ethanes
etoiles7411293_etoiles
exhales1737143_exhales
females12310663fe_males
ferals94216643fe_ral_s
ferrates113013423ferrates
ferrules1136163ferrules
ferules103112723fe_rules
fetialis11358663fetialis
fetials103711743fetial_s
fettles103912733fet_tles
heralds1137713he_ralds
impetrates1445453impetrates
iterates81317823iterates
kettles113411613ket_tles
laetriles944663laetriles
lethals1038113lethal_s
merles85322763me_r_les
metages102714973met_ages
metaled102913883met_aled
metals84520883met_al_s
metates92720013met_ates
meterages1248183meterages
methanes133812163methanes
metres85121563metr__es
mettles94115023met_tles
morales93619403_morales
nettles73214083net_tles
neutrals846283neutral_s
nitrates82516223nitrates
nitriles8269923nitriles
operates10515413ope_rates
outraces102217863outraces
outrages92215933outrages
outrates82421373outrates
outraves112313833outraves
pales75753803p___ales
parables121613563p_arables
parades104121463p_arades
parles86334403p_ar_les
paroles95025883p_aroles
parrals94414573parral_s
partakes1449923partakes
pastorales1247133pastorales
patriates11311363patriates
patrols93513513patrol_s
peaces106324083pe__aces
peages94321853pe__ages
pealed95322813pe__aled
peals75235493pe__al_s
pearled10411553pear_led
pearler9310373pear_ler
pearlers1039033pear_lers
pearls84715393pear_l_s
peases85229473pe__ases
pebbles1337573pe_bbles
pectases122411193pectases
pectates122213953pectates
pectorals13128153pectoral_s
pedaled113711893pe_daled
pedaler103410693pe_daler
pedalers11239393pe_dalers
pedalos10329703pe_dalos
pedals94316033pe_dal_s
peddles112913703pe_ddles
pedicles1338683pedicles
peerage1089803peerage_
peeries93623023peer_ies
peerless1037513peer_less
pelages10714613pe_lages
peles75738083pe___les
peltries10313023peltr_ies
penates93321603pe_nates
penetrates1248723penetrates
pennames12287793pennames
pentacles1338773pentacles
pentanes10316083pentanes
peonages1138473peonages
peoples11312223pe_oples
peptalks1653843peptalks
percale11314093percale_
perches143717953pe_rches
perdues103511333pe_rdues
peres76246643pe_r__es
periled10316323pe_riled
perils84121853pe_ril_s
perorates11417023perorates
perplex1836153pe_rplex
perries93226603pe_rries
persalts1038193persalts
perses85428063pe_r_ses
pertains102113423pertains
perukes133210113pe_rukes
peruses94018163pe_ruses
pervades1437353pervades
pesades10310903pe_sades
pestholes1448233pestholes
pestles93217693pe_stles
petal76526893pet_al__
petalled1138713petalled
petalous1058973pet_alous
petards104311153pet_ards
petasos948603pet_asos
petasus946363pet_asus
petiole9311303petiole_
petioled1137993petioled
petites93820203pet_ites
petnaper1243913petnaper
petnapers1343823petnapers
petnaps1145033petna_ps
petrel83111533petr__el
petrifies14310363petrifies
petrol82714063petrol__
petroleum1353303petroleum
petroleums1452803petroleums
petrolic1249693petrolic
petronel1048143petronel
petronels1146063petronels
petrous92714423petr_ous
petsais938433petsa_is
pettable121710713pettable_
pettle84116053pet_tle_
pettled103611513pet_tled
peytral1287503peytral__
peytrels1363373peytrel_s
phorates13413043phorates
phrases12711463p_hrases
picrates122013213picrates
pinwales1367963pinwales
pirates93020333p_irates
pitfalls1345373pitfalls
plurals936913plural_s
poetries10315583poetr_ies
portables1337873portables
portages112613223portages
portaled11239203portaled
portals94015563portal_s
potables12179703potables
potages102416423pot_ages
potholes13312933potholes
pottages112910453pottages
pottles93816983pot_tles
prases84429023p__rases
prates84633163p__rates
praxes156215183p__raxes
presales10315263presales
pretapes122811533pret_apes
pretrains11410143pretrains
pretravel1444123pretravel
pretrials1158143pretrial_s
proles84627203p__roles
prorates10418073prorates
psoralea1083433psoralea
psoraleas1172863psoraleas
psoralen1063453psoralen
psoralens1182823psoralens
purfles122511843p_urfles
purples112712833p_urples
pyrroles1345453pyrroles
quetzales2741943quetzales
rales54947493___rales
reales64934123re__ales
recrates102420373recrates
reframes1338993reframes
regales83520793re_gales
regrades103212173regrades
regrates92618403regrates
resales74724903re_sales
rescales103414573rescales
retables101712673retables
retakes113718863ret_akes
retapes93917423ret_apes
retaxes143615093ret_axes
reticles103912483reticles
retiles74426993ret_iles
retitles83612593retitles
retrace91417343retrace_
retraced111413023retraced
retracer101411883retracer
retracers11149553retracers
retracks14149103retracks
retracts101111313retracts
retrains8314533retrains
retral64419743retral__
retrally11310523retrally
retrials8510823retrial_s
retries74129073retr_ies
serapes95218103se_rapes
serrates82617023serrates
settles73916003set_tles
stales65538293_st_ales
strafes104516003_strafes
strakes114218073_strakes
tales55451373__t_ales
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
tetrads82910193tetra_ds
tetramer1046813tetramer
tetramers1146463tetramers
tetras63017623tetra__s
tetrodes939093tetrodes
tetryls1034643tetryl_s
titrates82314663titrates
traces85329933__traces
trades75724503__trades
trapes85024463__trapes
traves94222743__traves
ventrals112910003ventral_s
wearables14155003wearables
wetwares1445953wetwares

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.423422437.4
2DLD Change Limit1461622548.06318127.5
3Display Results2542540.1102309.1
 (SQL Overall)1786912548.59620787.7
 
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.