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

126 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
underlet9151621(None) 
underlets10158891underlets
underlit91311531underlit
underset91417131underset
underact11311512underact
underate9918602underate
undercut1148662undercut
undereat9313902undereat
underfed13311712underfed
underheat1348382underheat
underlap11146422underlap
underlay12147652underlay
underlie91413122underlie
underlies101414202underlies
underlip11157202underlip
underplot1246822underplot
undersea9149882undersea
undersets10129322undersets
undervest1398672undervest
underwent1349052underwent
coverlet13413013coverlet
interlent9416733interlent
overlet102619033_overlet
rondelet9410353ronde_let
rundlet83114153rund__let
sterlet71318473_sterlet
sundered10312153sunder_ed
sunderer9310523sunder_er
umbellet1247073umbellet
unbelt83015693unbe_l_t
uncurled1168963uncurled
undecked16238493undecked
undee65327273unde__e_
undefiled1446113undefiled
undeleted1148063unde_leted
undenied102211563undenied
undented102313953undented
under64624213under___
underacts1248583underacts
underage101012273underage
underaged121011233underaged
underages11811083underages
underarm1147843underarm
underbid12108203underbid
underbite1249813underbite
underbred1338993underbred
underbud12136213underbud
underbuy14125383underbuy
underclad1345563underclad
underclay1545063underclay
undercoat1248733undercoat
undercuts1246643undercuts
underdid11128133underdid
underdo937363under_do
underdoes1139103underdoes
underdog1145353underdog
undereats10310223undereats
underfeed1448633underfeed
underflow1643943underflow
underfoot1347033underfoot
underfur1245093underfur
undergirt1147813undergirt
undergo937043under_go
undergod1136583undergod
undergoer1146793undergoer
undergoes1139053undergoes
underheats1446053underheats
underived14310513underived
underjaw1943993underjaw
underlaid1147493underlaid
underlain1048683underlain
underlaps12146823underlaps
underlays13146883underlays
underline101714673underline
underlined121610213underlined
underlines111512113underlines
underling111514613underling
underlips12147673underlips
underload1146373underload
undermost1247963undermost
underneath1444053underneath
underpart1288513underpart
underpay14136213underpay
underpin1138843underpin
underplay1545193underplay
underplots1345403underplots
underran948423underran
underrate10411893underrate
underreact1344683underreact
underrun986813underrun
underseas1087803underseas
undersell1045763undersell
undershot1346893undershot
undertax1646113undertax
undertint10414863undertint
undertow1266233undertow
underuse939753underuse
underused1139333underused
underuses1039913underuses
undervests1464743undervests
undervote1357753undervote
underway15136343underway
underwear1344763underwear
undevout1246083undevout
undreamt1156543undreamt
undrest8313013und_rest
undrew1037913und_r_ew
undried92314613und_ried
undulled1036993undulled
unfelt92413463unfe_l_t
unfurled1277203unfurled
unhealed121511073unhealed
unkeeled13117183unkeeled
unlet54133333un___let
unmeet83815743unme__et
unnerve1066653unnerve_
unnerved1248063unnerved
unnerves1157273unnerves
unpeeled11118533unpeeled
unperfect1643643unperfect
unreeled91310333unreeled
unreeler8127293unreeler
unsealed91513623unsealed
unserved12410233unserved
unveiled1298163unveiled
unversed122310433unversed

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 Limit1461621267.50019488.3
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.96922423.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.