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

36 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
pamphlet174573(None) 
pamphlets1842751pamphlets
ample94720303_amp_le_
ampler104313303_amp_ler
amplest11312333_amp_lest
ampule10710613_ampule_
ampules1189433_ampules
amulet8419573_am_ulet
applet105917433_a_pplet
camlet104426583cam__let
capelet11517073ca_pelet
caplet104226813ca_p_let
hamlet113722793ham__let
nymphet1764323nymph_et
palet74650803pa___let
pallet84232653pa__llet
pamper124316663pamp__er
pampered15229233pampered
pamperer14228333pamperer
pamphleteer206913pamphleteer
pantalet10415903pantalet
papule102212133pa_pule_
papules112411573pa_pules
partlet92720363pa_rtlet
pimple123512963pimp_le_
pimpled14289193pimp_led
pimples133012423pimp_les
prophet14316033proph_et
rampole1139693rampole_
rampoles1238893rampoles
samlet84126563sam__let
sample104215013samp_le_
sampled123410793samp_led
sampler113212013samp_ler
samples112815453samp_les
templet112712003temp_let

Search took 10 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 Limit146162368.86016496.8
3Display Results36360.0132769.2
 (SQL Overall)178691369.29619222.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.