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

216 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
petioles1031164(None) 
petiole9311301petiole_
petioled1137991petioled
etoiles7411292_etoiles
fetiales11319612fetiales
ostioles839272ostioles
pedicles1338682pedicles
pestholes1448232pestholes
petiolar1046172petiolar
petiolules1252582petiolules
petites93820202peti_tes
petrales10312982petrales
petrols92913082petrol_s
pettles93916482pet_tles
potholes13312932potholes
reticles103912482reticles
retiles74426992reti_les
retitles83612592retitles
aediles83413903aedi_les
anetholes1246673anetholes
antipoles11810473antipoles
articles10310243articles
benzoles1936993benzoles
betides104915263beti_des
betimes115114413beti_mes
betises94816123beti_ses
carioles10817073carioles
centiles103615813centi_les
centrioles1245803centrioles
citoles9312553cit_oles
cuticles1237893cuticles
darioles9710693darioles
deciles104417723deci_les
defiles114016843defi_les
denticles1237753denticles
detinues9569823detinues
detoxes1538803det_oxes
edibles1048003_edibles
ediles74016983_edi_les
enisles72312603_enisles
entitles8710663entitles
epitomes1257713epitomes
epitopes1246973epitopes
ethoses10311763_ethoses
etiolates949213_etiolates
etoile6312263_etoile_
exiles134816403_exi_les
fetialis11358663fetialis
fetials103711743fetial_s
fetiches1636953fetiches
fetishes1437153fetishes
fettles103912733fet_tles
gentiles93713523genti_les
hemiolas1387063hemiolas
intitles8710003intitles
ketols104210763ket_ol_s
ketones115014503ket_ones
ketoses114912873ket_oses
kettles113411613ket_tles
keyholes1844593keyholes
meioses9310833me_ioses
metisses1036833metisses
metols84115773met_ol_s
metopes11311363met_opes
mettles94115023met_tles
motiles93317433moti_les
nettles73214083net_tles
orioles7412993_orioles
ostiole739013ostiole_
outsoles8813113outsoles
panicles121010113panicles
pantiles103617153panti_les
paroles95025883p_aroles
particles1339803particles
pastilles1148703pastilles
pathoses13412773pathoses
patines95225763pati_nes
patios85221783patio__s
patrols93513513patrol_s
pebbles1337573pe_bbles
pectines121914683pecti_nes
pectizes21229793pecti_zes
peddles112913703pe_ddles
pedicels1336253pedicels
pedicle1238973pedicle_
pedicled1436463pedicled
peepholes1646283peepholes
pegboxes2043143pegboxes
peises84125043pe_i_ses
pekoes124410423pe_ko_es
peles75738083pe___les
pelisses1048483pelisses
pelites93821993peli_tes
pellicles1344923pellicles
penile82219603peni_le_
penises9318193peni_ses
pensiones11410003pensiones
pentacles1338773pentacles
pentodes11310363pentodes
pentoses10312893pentoses
peones83821043pe__ones
peoples11312223pe_oples
peploses1269473peploses
peptides132610263pepti_des
peptizes21269853pepti_zes
peptones12311033peptones
percales12313803percales
pergolas1158233pergolas
periblem1445513periblem
periblems1543483periblems
pericopes1547873pericopes
perigees1189503perigees
periled10316323peri_led
perillas10310823perillas
perilled11410113perilled
perilous10310693perilous
perils84121853peri_l_s
periods10312243perio_ds
periques1937653periques
perishes13313753perishes
perniones1148593perniones
pesthole1347553pesthole_
pestles93217693pe_stles
petaled103614153pet_aled
petalled1138703petalled
petalous1058973petalous
petals84719813pet_al_s
petasoses1145443petasoses
petcocks1844583petcocks
petiolate1149153petiolate
petiolule1152253petiolule
petite84320653peti_te_
petrale9312623petrale_
petrels9279373petrel_s
petrifies14310363petrifies
petrol82714063petrol__
petroleum1353303petroleum
petroleums1452803petroleums
petrolic1249693petrolic
petronel1048143petronel
petronels1146063petronels
petrous92714423petro_us
pettitoes1144183pettitoes
pettle84116053pet_tle_
pettled103611513pet_tled
peyotes1238483pe_yotes
pieholes13168913pieholes
pieties9419223pieti__es
piles74742613p__i_les
pinholes131810663pinholes
pinoles93418703p_inoles
piolet83225643p__iolet
piolets93513193p__iolets
pistoles102514723pistoles
pities83828083piti__es
pitiless10127333piti_less
poetises10313953poeti_ses
poetizes19310253poeti_zes
poles75351003p___oles
portholes14410373portholes
posoles9314883p_osoles
postholes14410453postholes
potables12179703potables
pothole12312173pothole_
potholed1448393potholed
potiches1539203potiches
potions93417423potio_ns
pottles93816983pot_tles
pozoles1839063p_ozoles
prefiles133113443prefi_les
proles84627203p__roles
ptoses83514673p_t_oses
pyrroles1345453pyrroles
ratholes11312413ratholes
refiles104122423refi_les
reptiles103913063repti_les
resiles74026543resi_les
resoles73823653re_soles
retables101712673retables
reticle94112623reticle_
reticules1139013reticules
reties65436193reti__es
retile65929673reti_le_
retiled84420513reti_led
retimes95020173reti_mes
retines75134673reti_nes
retinols8419743retinol_s
retinues85113153retinues
retirees84611653retirees
retires74726213reti_res
retitle73913093retitle_
retitled9339553retitled
retooled938473retooled
retools73411023retool_s
reviles104421353revi_les
rutiles74315843ruti_les
semioses10611013semioses
seniles72618023seni_les
settles73916003set_tles
sextiles1537643sexti_les
stifles103013393_stifles
stiles64328773_sti_les
stoles63927673_st_oles
testicles1146773testicles
tetrodes939093tetrodes
textiles1536833texti_les
tholes94919783__tholes
tiles55542103__ti_les
titles63719923__titles
toiles63923513__toiles
toles55147133__t_oles
varioles11711123varioles
vehicles16204683vehicles
vesicles13127073vesicles
vetoes92914083vet_o_es
zeppoles2143583zeppoles

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 Limit1461622167.56319325.9
3Display Results2162160.0932322.6
 (SQL Overall)1786912168.07922118.0
 
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.