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

193 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
engram931065(None) 
engrams1038071engrams
anagram1058192anagram
enframe1247362enframe
engraft11118622engraft
engrail846262engrail
engrain838352engrain
engramme1344052engramme
engrave1137132engrave
enorm74415642enor_m
entrap8710562entrap
enwrap1185212enwrap
epigram1247472epigram
genogram1246732genogram
gram77034582__gram
pangram1239022pangram
renogram1147952renogram
tangram1038072tangram
venogram1476592venogram
aerogram1149523aerogram
anagrams1146593anagrams
anga56831353ang_a_
angary10311323angary
angas65827983ang_as
angora71111573angora_
angoras8811363angoras
angry9310863angr_y
anorak1038923anorak
antra56521923antra_
antral65719413antral
antrum8611313antrum
anural65714743anural
anuran64313243anuran
ashram1139053ashram
begrim11118333begrim
centigram1443983centigram
centra84113883centra_
central93114473central
centrum1168603centrum
cram85635493__cram
decagram1444653decagram
decigram1445353decigram
dekagram1643283dekagram
diagram1147363diagram
diram84419473_diram
dram75832003__dram
eagre64315323eagr_e
eagres74014573eagres
echogram1646393echogram
egad64215413e_g_ad
egal55119433e_g_al
eggar7458883e_ggar
eggars8398973eggars
egret63327313e_gret
encamp1235943en_camp
endear74110013endear
endgame1145233endgame
endrin7312403endrin
enema7612743enema_
enemas8812003enemas
energy10137513energy
enflame1236573enflame
enframed1466263enframed
enframes1357453enframes
eng46726783eng___
engage82812103engage
engild8107613engild
engine71114863engine
engird8126973engird
engirds995053engirds
engirt71112613engirt
englut738453englut
engorge945543engorge
engrafts1294703engrafts
engrails945383engrails
engrains937583engrains
engrammes1444513engrammes
engrammic1652863engrammic
engraved1335813engraved
engraver1245333engraver
engraves1237233engraves
engross837123engross
engs56121393eng__s
engulf1038883engulf
enigma935643enigma_
enigmas1045173enigmas
ennead736253ennead
enrage72715073en_rage
enrapt8313013en_rapt
enrol51014283en_rol
entera64216833entera_
enteral73516443enteral
enthral103410933enthral
entia5318203entia_
entrain7313073entrain
entrant7318873entrant
entraps9109763entraps
entreat7315263entreat
entree61817883entree
entry82414263entr_y
enure53520223enur_e
enured73315333enured
enures63919713enures
enwraps1284833enwraps
enzym1964393en_zym
epigrams1346113epigrams
era35741503e__ra_
eras45441503e__ras
estral64716513estral
estray95713333estray
estrum81810513estrum
ethogram1446353ethogram
exam132514623e__xam
extra1239003extra_
extras13310223extras
eyra76217553e_yra_
eyras84715923e_yras
foram105124933_foram
gam67060063__g_am
genera71211713genera_
general81010933general
genograms1345623genograms
gingham1484463gingham
glam76529343__glam
grab75427613__grab
grad66829863__grad
grama85620283__grama
gramp106218323__gramp
grams85327313__grams
gran56335013__gran
grat55651283__grat
gray85329893__gray
grim76929423__grim
grogram1147073grogram
grum75625083__grum
hexagram2143683hexagram
ideogram1245743ideogram
ihram10310183_ihram
inarm7314423inar_m
infra838643infra_
ingraft1199503ingraft
ingrain839523ingrain
ingrate8715123ingrate
inseam8329993inseam
inwrap11115903inwrap
isogram1047253isogram
jagra1338173jagra_
jagras1438463jagras
joram145816983_joram
lingam95112353ling_am
logjam1635363logjam
mantram114011603mantram
marram10313883marram
megrim1178043megrim
menorah1247933menorah
monogram1379183monogram
nam55953393_n__am
nanogram1145673nanogram
neural6311993neural
nizam16310253_nizam
norm66429813_nor_m
ogam75120033_og_am
ogham1138253_ogham
ondogram1245563ondogram
pangrams1337153pangrams
pentagram1444673pentagram
pogrom1138593pogrom
pram85733493__pram
program12311693program
ram56867273___ram
renograms1246763renograms
scram910621623_scram
senora63216163senora_
senoras72714953senoras
sonogram1167503sonogram
tagrag837043tagrag
tangrams1136163tangrams
telegram1146003telegram
thiram1139963thiram
tram67034553__tram
trigram1077763trigram
unarm7314453unar_m
undraw1037813undraw
ungual738183ungual
unjam1448723un_jam
unseam83313143unseam
untrim8310683untrim
unwrap11126323unwrap
vagrom1235943vagrom
venograms1545473venograms
ventral103612173ventral
wigwam1544723wigwam
ziram163912893_ziram

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 Filter1786911127160.610292936.1
2DLD Change Limit1127161935.42020796.3
3Display Results1931930.0633063.5
 (SQL Overall)1786911936.09329327.3
 
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.