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

110 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
programs133978(None) 
grograms1246021grograms
program12311691program_
aerograms1248152aerograms
barograms1445862barograms
deprograms1655462deprograms
grogram1147072grogram_
isograms1146472isograms
pangrams1337152pangrams
picograms1645722picograms
pogroms1237642p_ogroms
prograde1247182prograde
programed1585892programed
programer1475602programer
programers1584402programers
programme1694782programme
programmes1784932programmes
progress1137022progress
reprograms1556222reprograms
trigrams11116352trigrams
aerogram1149523aerogram_
anagrams1146593anagrams
barogram1346533barogram_
brogans1049663brog_ans
broughams1742403broughams
cartograms1545113cartograms
deprogram1555913deprogram_
diagrams1246133diagrams
echograms1745653echograms
engrams1038073_engrams
epigrams1346113epigrams
ethograms1545433ethograms
forams115115913_fo_rams
genograms1345623genograms
grams85327313___grams
holograms1547363holograms
ideograms1344803ideograms
isogram1047253isogram_
jorams154810533_jo_rams
kilograms1645043kilograms
kymograms2143673kymograms
logjams1743583_logjams
logograms1354693logograms
micrograms1747783micrograms
misprograms1852683misprograms
monograms1478263monograms
nanograms1244843nanograms
nephograms1844493nephograms
nomograms1445373nomograms
ogams84112683__og_ams
oghams1245853__oghams
ondograms1344563ondograms
pangram1239023pangram_
phonograms1845703phonograms
photograms1848193photograms
picogram1546523picogram_
pictograms1744623pictograms
pilgrims1344143pilgrims
pingrass1146003pingrass
pogrom1138593p_ogrom_
portrays1345293portrays
praams10459643pr__aams
prams96125513p___rams
prearms11369173prear_ms
pregame1239553preg_ame
pregames1339003preg_ames
preprograms1864113preprograms
pretrims1238983pretrims
prewarms15406733prewarms
prewraps15114053prewraps
proas75028803pro__a_s
problems1434343problems
procarps1445973procarps
proclaims1545073proclaims
procurals1355283procurals
prodrome1346203prodrome
prodromes1446063prodromes
prodrugs1242483prodrugs
proems104711163pro__ems
progerias1248623progerias
proggers12258163proggers
programing1646313programing
programings1753423programings
programmed1883883programmed
programmer1794113programmer
programmers1893533programmers
progs86624153prog___s
prolans9314273pro_lans
proms95426413pro___ms
prorate9418733pro_rate
prorates10418073pro_rates
prosomas1249723prosomas
proteans102811543proteans
proteas92015123protea_s
protiums1238553protiums
protract12510603protract
protracts1347023protracts
protrade1148213protrade
pyelograms1843763pyelograms
pyrocerams1952643pyrocerams
renograms1246763renograms
reprogram1456613reprogram_
roams74919613_ro__ams
sonograms1296303sonograms
subprograms1852733subprograms
tangrams1136163tangrams
tomograms1445893tomograms
trigram1077763trigram_
venograms1545473venograms
zymograms2643863zymograms

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.406440125.6
2DLD Change Limit1461621107.36019859.0
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.81222873.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.