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

96 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
pyramid154751(None) 
pyralid1347981pyralid
pyramids1645641pyramids
aramid93315612_aramid
bipyramid1952092bipyramid
peracid12312992peracid
pyralids1445812pyralids
pyramidal1744012pyramidal
pyramided1873832pyramided
pyramidic1943772pyramidic
pyranoid1447282pyranoid
afraid1049723afra_id
agamid103710693_agamid
amid77036353___amid
aramids102810513_aramids
barmaid1238203barmaid
bipyramids2051343bipyramids
braid85822263_bra_id
bromid112612893_bromid
carabid12311333carabid
ceramic1339823ceramic
ceramide1347973ceramide
cyanamid1644223cyanamid
cyanid123912043cy_anid
dynamic1545813dynamic
framed125116523_framed
gravid113710983_gravid
gyrated12428413gyrated
hydatid1546523hydatid
hydracid1844983hydracid
hyracoid1745973hyracoid
keramic1537233keramic
lyrated11388473lyrated
mermaid1297853mermaid
paid75737483p__a_id
paraded114014263paraded
paramo102614643param_o
paramos113213513paramos
paranoid11311143paranoid
parotid102915513parotid
pavid115717003p__avid
peracids13310073peracids
percoid12312313percoid
permed115217353per_med
permit10321683per_mit
peroxid17310273peroxid
phasmid15267603phasmid
phrased1387383phrased
pirated102515613pirated
piratic11314293piratic
placid114012543p_lacid
plaid85118303p_la_id
plasmid12239553plasmid
potamic13310853potamic
pram85733493p_ram__
prams96125513p_ram_s
prated94924923p_rated
praxis154012253p_raxis
prayed124815433p_rayed
prebid113512843p_rebid
premed114617763p_remed
premie103617993p_remie
premix173710333p_remix
primed115118913p_rimed
primi95017403p_rimi_
puranic11410483puranic
pyaemia1445733pyaemia
pyaemic1645873pyaemic
pyemia1337553py_emia
pyemic1537893py_emic
pygmoid1644533pygmoid
pyjama20303483pyjam_a
pyjamas21263523pyjamas
pyoid11513763py__oid
pyralidid1653643pyralidid
pyramiding1943533pyramiding
pyran10514473pyra__n
pyrans11411063pyra_ns
pyrenoid1446873pyrenoid
pyretic143210783pyretic
pyrexia19225463pyrexia
pyrexic21235353pyrexic
pyric123815073pyr__ic
pyridic15267833pyridic
pyritic143311313pyritic
pyrosis12411653pyrosis
pyrrhic1744073pyrrhic
rabid84520783__rabid
raid55243073__ra_id
rami66034093__rami_
ramie75027823__ramie
ranid66429333__ranid
rapid86422033__rapid
syrphid1646103syrphid
tyramine1347303tyramine
upbraid1244973upbra_id

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 Filter1786911340270.406440125.6
2DLD Change Limit134027966.39020974.5
3Display Results96960.0332909.1
 (SQL Overall)178691966.82926166.5
 
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.