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

138 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
underlies10141420(None) 
underlie91413121underlie_
underlines111512111underlines
underlips12147671underlips
elderlies1044672elderlies
orderlies1045452orderlies
underages11811082underages
underbids13137242underbids
underbites1347892underbites
underdoes1139102underdoes
undergoes1139052undergoes
underlaps12146822underlaps
underlays13146882underlays
underlet91516212underl_et
underlets10158892underlets
underline101714672underline
underlined121610212underlined
underling111514612underling
underlings12178142underlings
underlip11157202underli_p
underlit91311532underli_t
undermines131710662undermines
underpins1239732underpins
undersides1248692undersides
underuses1039912underuses
underwires1447022underwires
alderflies1452443alderflies
anergies9310453an_ergies
binderies12311683binder_ies
dellies83622213__dellies
derbies103016053__derbies
derries83124623__derries
energies9310783en_ergies
ferlies103216693__ferlies
gunneries1047043gunner_ies
interlines101116453interlines
interties9320333interties
nellies73418723_n_ellies
nunneries947113nunner_ies
overlies112417043_overlies
ruderies9311333ruder_ies
sundries9312023sund_r_ies
superlies11314553superlies
unbelief1346773unbe_lief
unbeliefs1442943unbe_liefs
undeceives1643863undeceives
undefiled1446113undefiled
undenied102211563unde_nied
underacts1248583underacts
underage101012273underage_
underaged121011233underaged
underarms1246733underarms
underate9918603underate_
underbakes1746363underbakes
underbellies1552283underbellies
underbid12108203underbi_d
underbite1249813underbite
underbodies1544663underbodies
underboss1246433underboss
underbred1338993underbred
underbrims1544063underbrims
underbuds13145593underbuds
underbuys15134703underbuys
underclass1344883underclass
underclays1644243underclays
undercuts1246643undercuts
underdid11128133underdi_d
underdogs1245753underdogs
underdose1157593underdose
underdoses1247003underdoses
undereats10310223undereats
underfed13311713under_fed
underfeed1448633underfeed
underfeeds1544233underfeeds
underflows1743943underflows
underfurs1355493underfurs
undergird1245903undergird
undergirds1344453undergirds
undergirt1147813undergirt
underglazes2243903underglazes
undergods1246333undergods
undergoer1146793undergoer
undergoers1245003undergoers
underhairs1445453underhairs
underived14310513underived
underjaws2044473underjaws
underkill1445073underkill
underkills1543803underkills
underlaid1147493underlaid
underlain1048683underlain
underlap11146423underl_ap
underlay12147653underl_ay
underload1146373underload
underloads1245233underloads
underlying15136373underlying
undermine122012233undermine
undermined14189133undermined
underpass12136783underpass
underpays15166113underpays
underpin1138843underpi_n
underplays1644653underplays
underplots1345403underplots
underprices1644723underprices
underrates11410563underrates
underripe1247833underripe
underruns1066733underruns
undersea9149883under_sea
underseas1087803underseas
underset91417133under_set
undersets10129323undersets
underside11310143underside
undersign1177113undersign
undersigns1265833undersigns
undersize1949513undersize
undersized2148213undersized
undersoils1156063undersoils
underspins1346833underspins
undertakes1547693undertakes
undertaxes1847023undertaxes
undertint10414863undertint
undertints1148283undertints
undertones1148973undertones
undertows1366683undertows
underuse939753underuse_
underused1139333underused
undervalues1544153undervalues
undervest1398673under_vest
undervotes1456533undervotes
underwing141410883underwing
underwings15146403underwings
underwire1348123underwire
underwrites1545183underwrites
undies73821963und___ies
undrapes1138603und_rapes
undresses1039313undresses
undried92314613und_r_ied
unnerves1157273unner_ves
updries10209083upd_r_ies

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411387.03321134.8
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.51623774.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.