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

102 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
engrain83835(None) 
engrail846261engrail
engrains937581engrains
entrain7313071entrain
ingrain839521ingrain
enchain1248862enchain
endbrain1144182endbrain
endrin7312402endr_in
engraft11118622engraft
engrails945382engrails
engrained1145492engrained
engram9310652engra_m
engrams1038072engrams
engrave1137132engrave
engraving1446012engraving
entrains8312962entrains
grain65126252__grain
ingrains948982ingrains
again65218123_ag_ain
angaria8311583angaria
anuran64313243anura_n
bargain1079063bargain
brain76229383__brain
detrain8412253detrain
drain65222893__drain
elain55324703e__lain
enchains1348523enchains
endbrains1244063endbrains
endrins8312163endr_ins
energid948303energid
enframe1247363enframe
enframing1546113enframing
engage82812103eng_age
engaging1147373engaging
engine71114863eng__ine
engining1039293engining
engirding1244153engirding
engorging1244873engorging
engrafting1544183engrafting
engrafts1294703engrafts
engrailed1144323engrailed
engrailing1244853engrailing
engraining1245223engraining
engramme1344053engramme
engrammic1652863engrammic
engraved1335813engraved
engraver1245333engraver
engraves1237233engraves
engravings1542503engravings
engross837123engross
enjoin1357833en_join
enrage72715073en_rage
enraging1049573en_raging
enrapt8313013en_rapt
entail61114343en_tail
entertain947863entertain
entrails8310163entrails
entrained1089413entrained
entrainer968583entrainer
entrant7318873entrant
entrap8710563entra_p
entraps9109763entraps
enuring8813883enur_ing
enwrap1185213enwra_p
enwraps1284833enwraps
estrin6315923estr_in
explain1667043explain
feedgrain1452073feedgrain
gain56042163__g_ain
gradin83517483__gradin
grail64622873__grail
grains74223093__grains
grainy103914213__grainy
gran56335013__gra_n
gratin74520583__gratin
grin55733723__gr_in
groin65521083__groin
indrawn1145093indrawn
ingraft1199503ingraft
ingrained1145383ingrained
ingrate8715123ingrate
ingrown1145393ingrown
ligroin848043ligroin
migraine1157863migraine
murrain937763murrain
negroid9108893negroid
negroni846833negroni
penguin1045873peng_uin
rain46251733___rain
refrain10310043refrain
regain74517763reg_ain
restrain8311703restrain
retrain7615423retrain
seatrain847923seatrain
sprain83614863_sprain
strain64919573_strain
terrain7410853terrain
train56529113__train
unbraid1037183unbraid
unchain1238943unchain
undrawn1145293undrawn
vitrain1038943vitrain

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 Limit1340271026.14321817.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.57927160.8
 
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.