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

107 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
pretyped1630612(None) 
pretaped13339131pretaped
pretype14387481pretype_
pretypes15337261pretypes
retyped13367301_retyped
prepped11329892pre_pped
pretape113511622pretape_
pretapes122811532pretapes
prettied1159252prettied
preyed125313192pre_y_ed
retaped103814282_retaped
retype11399142_retype_
retypes12308622_retypes
creeped12329713cre_eped
creped114115703cre__ped
fretted113411853fret_ted
greyed114610603gre_y_ed
mistyped1685173mistyped
peeped113915383p_e_eped
pepped103113393p_e_pped
petaled103614143p_etaled
petered103314963p_etered
petted94121523p_et_ted
pettled103611503p_ettled
poetised1138523poetised
poetized2037983poetized
polyped1537173p_olyped
prated94924923prat__ed
prattled11246533prattled
prayed124815433pr_ay_ed
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
prearmed1397993prearmed
prebaked1737173prebaked
preceded1438283preceded
precipe133012123precipe_
precipes143212213precipes
precised133213413precised
precited133013813precited
precoded1438863precoded
precured1339993precured
predated12513273predated
predried12309573predried
preed85128113pre___ed
preempted1644683preempted
preened103214983pre_ened
prefaced1638423prefaced
prefaded1537823prefaded
prefiled143310573prefiled
prefired144310753prefired
prefixed21357693prefixed
preluded1236463preluded
premed114617753pre__med
premised133013193premised
premixed20338003premixed
prenticed14118063prenticed
preowned1435213preowned
prepared132210863prepared
prepaved16177223prepaved
presaged1238803presaged
preshaped1745523preshaped
presided12410553presided
pressed103317313pre_ssed
prestamped1742963prestamped
prestored125111673prestored
presumed1337973presumed
pretasted12147963pretasted
preteen939873pret_een
pretend104011013pret_end
pretended1337193pretended
pretested12149113pretested
pretexted19135683pretexted
pretold1049083pret_old
prettier1069043prettier
pretties10615133pretties
pretyping1764943pretyping
pretzel1835143pret_zel
prevised143611073prevised
prevued1337143pre_vued
prewired14358473prewired
preyer114413733pre_y_er
primped14479153pr_imped
propped113311953pr_opped
protopod1347353protopod
prototyped1844283prototyped
protyle12229453protyle_
protyles13249833protyles
reaped94122453_re_aped
redyed114611233_redy_ed
repped114616723_re_pped
restyled1236943_restyled
retape83917683_retape_
retapes93917423_retapes
retaxed153512233_retaxed
retched133814273_retched
retied75924983_ret_ied
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
retried84419153_retried
retted74826313_ret_ted
retuned86613973_retuned
serotyped1543843serotyped
teletyped15113493teletyped
typed115815453___typed
wretched17276533wretched

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.1561145455.1
2DLD Change Limit1461621077.67319048.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.87522690.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.