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

108 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
underpin113884(None) 
underpins1239731underpins
underspin1246651underspin
underbid12108202underbid
underdid11128132underdid
underlain1048682underlain
underlie91413122underlie
underline101714672underline
underling111514612underling
underlip11157202underlip
underlit91311532underlit
undermine122012232undermine
underpaid1346962underpaid
underpay14136212underpay
underran948422underran
underrun986812underrun
undersign1177112undersign
underspins1346832underspins
undertint10414862undertint
underwing141410882underwing
endbrain1144183endbrain
endermic1356173endermic
endorphin1555153endorphin
endrin7312403end_r_in
invertin11910233invertin
sidespin1143943sidespin
sundering11312323sunder_ing
uncertain1146203uncertain
undaring10412753undar_ing
under64624213under___
underact11311513underact
underage101012273underage
underarm1147843underarm
underate9918603underate
underbids13137243underbids
underbite1249813underbite
underbrim1444633underbrim
underbud12136213underbud
underbuy14125383underbuy
undercut1148663undercut
underdo937363under_do
underdog1145353underdog
underdoing1346803underdoing
underdone1158213underdone
undereat9313903undereat
underfed13311713underfed
underfund1445373underfund
underfur1245093underfur
undergird1245903undergird
undergirt1147813undergirt
undergo937043under_go
undergod1136583undergod
undergoing1347083undergoing
undergone1158273undergone
underhair1345733underhair
underhand1447263underhand
underhung1445183underhung
underjaw1943993underjaw
underkill1445073underkill
underlaid1147493underlaid
underlap11146423underlap
underlay12147653underlay
underlet91516213underlet
underlies101414203underlies
underlined121610213underlined
underlines111512113underlines
underlings12178143underlings
underlips12147673underlips
underlying15136373underlying
undermined14189133undermined
undermines131710663undermines
underpants1346913underpants
underpart1288513underpart
underpass12136783underpass
underpaying18125373underpaying
underpays15166113underpays
underpinned1544053underpinned
underplay1545193underplay
underplot1246823underplot
underprice1545513underprice
underprop1444353underprop
underripe1247833underripe
underruns1066733underruns
undersea9149883undersea
underset91417133underset
underside11310143underside
undersigns1265833undersigns
undersize1949513undersize
undersoil1056773undersoil
undersong1147993undersong
undertax1646113undertax
undertints1148283undertints
undertone10510203undertone
undertow1266233undertow
underuse939753underuse
underusing1247263underusing
underway15136343underway
underwent1349053underwent
underwings15146403underwings
underwire1348123underwire
undraping1337333undraping
undrawn1145293und_rawn
unerring9311273un_erring
unheroic1345263unheroic
unnerving1336633unnerving
unperson1046383unperson
unpin72613243un___pin
wunderkind1942733wunderkind

Search took 9 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.420425454.8
2DLD Change Limit1461621087.58019282.6
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.04622208.7
 
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.