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

42 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
puppetry144250(None) 
peppery13286252peppe_ry
puppet93514592puppet__
puppets10317012puppet_s
coppery16409393coppe_ry
cupper124313863cuppe_r_
cuppers133712213cuppe_rs
dupery12378743du_pe_ry
foppery17385623foppe_ry
musketry1742183musketry
papery134812743p_ape_ry
papistry1543723papistry
pepper93512943peppe_r_
peppers103311443peppe_rs
poetry1139383__poetry
popery134511703p_ope_ry
popper93615963poppe_r_
poppers103414863poppe_rs
poppet92717323poppet__
poppets10338853poppet_s
property1547073property
puberty1444783pu_berty
puckery18306263pucke_ry
puffery18235113puffe_ry
pulper103513273pulpe_r_
pulpers114612283pulpe_rs
pumper124415553pumpe_r_
pumpers133113673pumpe_rs
punditry1442513punditry
pupilary15104123pupilary
pupped105013273puppe__d
puppeteer1242443puppeteer
puppeteers1361983puppeteers
puppetries1343883puppetries
puppy114912413pupp___y
supper104115433suppe_r_
suppers113314703suppe_rs
suppletory1751983suppletory
tuppenny1541633tuppenny
upper93714263_uppe_r_
uppers102912293_uppe_rs
uppity1335103_uppit_y

Search took 7 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 Limit146162426.54622328.4
3Display Results42420.0162625.0
 (SQL Overall)178691426.98525582.1
 
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.