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
petrales1031295(None) 
petrale9312621petrale_
fetiales11319612fetiales
peerages1189882peerages
percales12313782percales
petaled103614142pet_aled
petals84719812pet_al_s
petioles10311632petioles
petrels9279372petrel_s
petrols92913082petrol_s
pettles93916482pet_tles
peytrals1355492peytral_s
retraces101417262retraces
aerates74627483ae_rates
apetalies1148003apet_alies
astrals75515243astral_s
australes9317763australes
bedrapes1386963bedrapes
berakes134815773be_rakes
berates94126853be_rates
betakes134212523bet_akes
betrayed1436303betrayed
betrayer1345643betrayer
betrayers1445013betrayers
betrays12127823betra_ys
centraler1146683centraler
centralest1247143centralest
centrals102712033central_s
cerates95428233ce_rates
cetanes9315133cet_anes
chorales133712873chorales
citrals91111663citral_s
citrates102315073citrates
degrades11269923degrades
depraves1436873depraves
derates84028883de_rates
detracts11138833detracts
detrains9411753detrains
detrudes1036193detrudes
empales112411433_empales
enrages83114853_enrages
erases64425403_e_rases
etapes85415293_et_apes
ethanes103713503_ethanes
etoiles7411293_etoiles
exhales1737143_exhales
females12310663fe_males
ferals94216643fe_ral_s
ferrates113013403ferrates
ferrules1136163ferrules
ferules103112723fe_rules
fetialis11358663fetialis
fetials103711743fetial_s
fettles103912733fet_tles
heralds1137703he_ralds
impetrates1445443impetrates
iterates81317813iterates
kettles113411613ket_tles
laetriles944663laetriles
lethals1038113lethal_s
merles85322763me_r_les
metages102714973met_ages
metaled102913873met_aled
metals84520883met_al_s
metates92720003met_ates
meterages1248173meterages
methanes133812163methanes
metres85121563metr__es
mettles94115023met_tles
morales93619403_morales
nettles73214083net_tles
neutrals846283neutral_s
nitrates82516203nitrates
nitriles8269923nitriles
operates10515403ope_rates
outraces102217863outraces
outrages92215933outrages
outrates82421363outrates
outraves112313833outraves
pales75753803p___ales
parables121613563p_arables
parades104121463p_arades
parles86334393p_ar_les
paroles95025883p_aroles
parrals94414573parral_s
partakes1449923partakes
pastorales1247133pastorales
patriates11311363patriates
patrols93513513patrol_s
peaces106324083pe__aces
peages94321843pe__ages
pealed95322803pe__aled
peals75235493pe__al_s
pearled10411533pear_led
pearler9310363pear_ler
pearlers1039023pear_lers
pearls84715383pear_l_s
peases85229473pe__ases
pebbles1337573pe_bbles
pectases122411183pectases
pectates122213933pectates
pectorals13128153pectoral_s
pedaled113711873pe_daled
pedaler103410693pe_daler
pedalers11239393pe_dalers
pedalos10329683pe_dalos
pedals94316033pe_dal_s
peddles112913693pe_ddles
pedicles1338663pedicles
peerage1089803peerage_
peeries93623023peer_ies
peerless1037503peer_less
pelages10714613pe_lages
peles75738083pe___les
peltries10313023peltr_ies
penates93321593pe_nates
penetrates1248713penetrates
pennames12287783pennames
pentacles1338763pentacles
pentanes10316073pentanes
peonages1138473peonages
peoples11312213pe_oples
peptalks1653843peptalks
percale11314083percale_
perches143717953pe_rches
perdues103511333pe_rdues
peres76246643pe_r__es
periled10316293pe_riled
perils84121853pe_ril_s
perorates11417013perorates
perplex1836133pe_rplex
perries93226603pe_rries
persalts1038193persalts
perses85428063pe_r_ses
pertains102113413pertains
perukes133210113pe_rukes
peruses94018163pe_ruses
pervades1437343pervades
pesades10310893pe_sades
pestholes1448233pestholes
pestles93217693pe_stles
petal76526893pet_al__
petalled1138683petalled
petalous1058963pet_alous
petards104311153pet_ards
petasos948603pet_asos
petasus946363pet_asus
petiole9311303petiole_
petioled1137993petioled
petites93820203pet_ites
petnaper1243913petnaper
petnapers1343823petnapers
petnaps1145033petna_ps
petrel83111533petr__el
petrifies14310353petrifies
petrol82714063petrol__
petroleum1353303petroleum
petroleums1452803petroleums
petrolic1249693petrolic
petronel1048143petronel
petronels1146063petronels
petrous92714423petr_ous
petsais938433petsa_is
pettable121710713pettable_
pettle84116053pet_tle_
pettled103611503pet_tled
peytral1287503peytral__
peytrels1363373peytrel_s
phorates13413043phorates
phrases12711463p_hrases
picrates122013203picrates
pinwales1367963pinwales
pirates93020323p_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
prorates10418063prorates
psoralea1083433psoralea
psoraleas1172863psoraleas
psoralen1063453psoralen
psoralens1182823psoralens
purfles122511843p_urfles
purples112712823p_urples
pyrroles1345453pyrroles
quetzales2741943quetzales
rales54947493___rales
reales64934123re__ales
recrates102420353recrates
reframes1338983reframes
regales83520793re_gales
regrades103212163regrades
regrates92618373regrates
resales74724903re_sales
rescales103414563rescales
retables101712673retables
retakes113718863ret_akes
retapes93917423ret_apes
retaxes143615093ret_axes
reticles103912483reticles
retiles74426993ret_iles
retitles83612593retitles
retrace91417343retrace_
retraced111413023retraced
retracer101411883retracer
retracers11149553retracers
retracks14149103retracks
retracts101111313retracts
retrains8314523retrains
retral64419743retral__
retrally11310523retrally
retrials8510823retrial_s
retries74129073retr_ies
serapes95218103se_rapes
serrates82617003serrates
settles73916003set_tles
stales65538293_st_ales
strafes104515993_strafes
strakes114218073_strakes
tales55451373__t_ales
terraces102712223terraces
terranes82514393terranes
terrases82111453terrases
tetrads82910173tetra_ds
tetramer1046813tetramer
tetramers1146443tetramers
tetras63017613tetra__s
tetrodes939073tetrodes
tetryls1034643tetryl_s
titrates82314643titrates
traces85329933__traces
trades75724493__trades
trapes85024463__trapes
traves94222743__traves
ventrals11299993ventral_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.1701051123.5
2DLD Change Limit1461622547.94018408.3
3Display Results2542540.1401814.3
 (SQL Overall)1786912548.25021659.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.