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

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
peptalks165384(None) 
peptalk1554821peptalk_
peptalked1842472peptalked
petals84719812pe_tal_s
uptalks1333722_uptalks
bechalks1944793bechalks
bytalks1632713_bytalks
centals94317053cental_s
dentals83915393dental_s
eyestalks16132343eyestalks
gestalts955493gestalts
heptads1335873hepta_ds
heptanes1339003heptanes
metals84520893me_tal_s
outtalks1236503outtalks
overtalks1645663overtalks
peaks114825623pe__a_ks
peals75235493pe__al_s
pectases122411193pectases
pectates122213953pectates
pedalos10329703pe_dalos
pedals94316033pe_dal_s
peltasts1035703peltasts
pentacles1338773pentacles
pentads1039523penta_ds
pentanes10316083pentanes
pentyls1236523pentyl_s
peplos101211543pep__los
peplus10138343pep__lus
peptalking1943253peptalking
peptics132610243pept_ics
peptides132610263peptides
peptids12239323pept_ids
peptizes21269853peptizes
peptones12311033peptones
percales12313803percales
persalts1038193persalts
pertains102113423pertains
pestles93217693pest_les
petal76526893pe_tal__
petaled103614153pe_taled
petalous1058973pe_talous
petards104311153pe_tards
petasos948603pe_tasos
petasus946363pe_tasus
petrales10312983petrales
pettles93916483pe_ttles
peytrals1355493peytral_s
pipals104213643pip_al_s
portals94015563portal_s
postals93716383postal_s
prepacks1836583prep_acks
rentals74017473rental_s
repacks15269543rep_acks
reparks13249513rep_arks
repeals94014523repeal_s
reptiles103913063reptiles
restacks1438093restacks
retacks132210713re_tacks
sepals85217383sep_al_s
septages1168263septages
septal84513383septal__
shoptalks1842673shoptalks
stalks104614553__stalks
talks94322693___talks
tepals85415043tep_al_s
uptalk1234653_uptalk_
vestals104612333vestal_s

Search took 8 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 Limit146162686.78321548.3
3Display Results68680.0302266.7
 (SQL Overall)178691687.23624694.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.