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

68 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
pedals9431603(None) 
medals94218051medals
peals75235491pe_als
pedal86022501pedal_
pedalo93811151pedalo
pedalos10329701pedalos
petals84719811petals
bedels94015272bedels
cedars93312832cedars
dals57145122__dals
deals65435342de_als
decals93717712decals
dedal75719022dedal_
dedans85915072dedans
ferals94216642ferals
heals85733452he_als
ideals75012502ideals
legals73412732legals
meals75933372me_als
medal86221332medal_
medials103914732medials
metals84520882metals
modals93914452modals
pals66951352p__als
peags86122842pe_ags
peaks114825622pe_aks
peal68648102pe_al_
peans75437642pe_ans
pearls84715392pearls
pears75138612pe_ars
peas65755062pe_a_s
peats76140192pe_ats
pecans101515832pecans
pedaled113711892pedaled
pedaler103410692pedaler
pedalers11239392pedalers
pedant9319492pedant
pedants10310112pedants
pedate93117762pedate
peddle103512822peddle
peddles112913702peddles
pedes85327292ped_es
pedlar93311272pedlar
pedlars103210212pedlars
pedocals1346082pedocals
pedros9312182pedros
peds75835242ped__s
peels75226422pe_els
pekans121710552pekans
penal75228372penal_
perils84121852perils
petal76526892petal_
phials1158872phials
pibals103813082pibals
pipals104213642pipals
reals55038652re_als
redans75421022redans
redials84416882redials
seals54839692se_als
sedans74816092sedans
sendals81912262sendals
sepals85217372sepals
teals56234132te_als
tepals85415042tepals
veals84926192ve_als
weals85428742we_als
wedels103811032wedels
zeals145320852ze_als

Search took 6 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.750238254.7
2DLD Change Limit82551684.56318091.4
3Display Results68680.0332060.6
 (SQL Overall)178691685.34633425.2
 
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.