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 “ingrain” 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
ingrain83952(None) 
engrain838351engrain
ingrains948981ingrains
engrail846262engrail
engrains937582engrains
entrain7313072entrain
grain65126252__grain
indrawn1145092indrawn
ingraft1199492ingraft
ingrained1145382ingrained
ingrate8715122ingrate
ingrown1145392ingrown
again65218123_ag_ain
angaria8311583angaria
anuran64313243anura_n
bargain1079063bargain
brain76229383__brain
cinerin9313823ciner_in
cinquain1943513cinquain
detrain8412253detrain
distrain9412243distrain
drain65222893__drain
enchain1248853enchain
endbrain1144183endbrain
endrin7312403endr_in
engraft11118613engraft
engrails945383engrails
engrained1145493engrained
engram9310653engra_m
engrams1038073engrams
engrave1137133engrave
engraving1446013engraving
entrains8312963entrains
gain56042163__g_ain
gradin83517483__gradin
grail64622873__grail
grains74223093__grains
grainy103914213__grainy
gran56335013__gra_n
gratin74520583__gratin
grin55733723__gr_in
groin65521083__groin
hindbrain1552853hindbrain
inarming1138343inarming
indamin1048043indamin
indraft1199563indraft
indri6310793indr_i_
indris7311963indr_is
indulin838773indulin
inertia7410203inertia
infra838643infra__
infract12610003infract
ingate73018243ing_ate
ingoing9311023ing_oing
ingoting1039863ingoting
ingrafting1544893ingrafting
ingrafts12105803ingrafts
ingraining1245623ingraining
ingrates9514173ingrates
ingress838653ingress
inground1044383inground
ingroup1044333ingroup
ingrowing1445533ingrowing
inhibin1244853inhibin
inlaid7310143in_laid
inrun52911373in_r_un
inspan837513inspa_n
insulin738483insulin
intrant7318753intrant
introit7414533introit
intron64215023intr_on
inulin6311733in_ulin
inuring81213013inur_ing
inurn53712863inur__n
inurning937553inurning
invertin11910233invertin
inwrap11115903inwra_p
inwraps12105253inwraps
kingpin1445003king_pin
ligroin848043ligroin
midbrain1343923midbrain
migraine1157863migraine
mistrain10311943mistrain
murrain937763murrain
nigrosin945233nigrosin
pingrass1146003pingrass
rain46251733___rain
refrain10310043refrain
regain74517763reg_ain
retrain7615423retrain
ringtail944723ringtail
sprain83614863_sprain
strain64919573_strain
terrain7410853terrain
train56529113__train
unbraid1037183unbraid
unchain1238943unchain
undrawn1145293undrawn
vitrain1038943vitrain
wingman1336383wingma_n
zingani1744813zing_ani
zingari1745483zingari_

Search took 10 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.1561145455.1
2DLD Change Limit1340271029.39014273.4
3Display Results1021020.0631619.0
 (SQL Overall)1786911029.60918596.2
 
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.