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 “petals” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
petals8471981(None) 
metals84520881metals
peals75235491pe_als
pedals94316031pedals
petal76526891petal_
acetals93411352acetals
apetaly1237252apetaly
betas75528762beta_s
betels84515062betels
centals94317052centals
deals65435342de_als
decals93717712decals
dentals83915392dentals
details84214042details
etas46432272_eta_s
ferals94216642ferals
fetal85623372fetal_
fetas85624402feta_s
fetials103711742fetials
getas65421482geta_s
heals85733452he_als
ketols104210762ketols
legals73412732legals
lethals1038112lethals
meals75933372me_als
medals94218052medals
metal75427382metal_
metols84115772metols
pals66951352p__als
peags86122842pe_ags
peaks114825622pe_aks
peal68648102pe_al_
peans75437642pe_ans
pearls84715392pearls
pears75138612pe_ars
peas65755062pe_a_s
peats76140192pe_ats
pecans101515832pecans
pedal86022502pedal_
pedalo93811152pedalo
pedalos10329702pedalos
peels75226422pe_els
pekans121710552pekans
penal75228372penal_
pentads1039522pentads
pentyls1236522pentyls
peptalk1554822peptalk
peptalks1653842peptalks
perils84121852perils
petaled103614142petaled
petalous1058972petalous
petard95013802petard
petards104311152petards
petasos948602petasos
petasus946362petasus
peters86624592peters
petnaps1145032petnaps
petrale9312622petrale
petrales10312982petrales
petrels9279372petrels
petrols92913082petrols
pets66248332pet__s
petsais938432petsais
pettle84116052pettle
pettles93916482pettles
peytrals1355492peytrals
phials1158872phials
pibals103813082pibals
pietas84516502pieta_s
pipals104213642pipals
pitas77427672pita_s
portals94015562portals
postals93716372postals
ratals64219582ratals
reals55038652re_als
rentals74017472rentals
retags73414302retags
retails74718972retails
seals54839692se_als
sepals85217372sepals
setal56430902setal_
spitals93011592spitals
steals64020062steals
teals56234132te_als
tepals85415042tepals
totals63115162totals
veals84926192ve_als
vestals104612332vestals
vitals94514302vitals
weals85428742we_als
zeals145320852ze_als
zetas145018162zeta_s

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551922.20337472.1
3Display Results92920.0303066.7
 (SQL Overall)178691922.34376265.9
 
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.