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

101 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
underlay1214765(None) 
underclay1545061underclay
underlap11146421underlap
underlays13146881underlays
underpay14136211underpay
underplay1545191underplay
underway15136341underway
interlay11310042interlay
underbuy14125382underbuy
underclad1345562underclad
underclays1644242underclays
undereat9313902undereat
underjaw1943992underjaw
underlaid1147492underlaid
underlain1048682underlain
underlaps12146822underlaps
underlet91516212underlet
underlie91413122underlie
underlip11157202underlip
underlit91311532underlit
underload1146372underload
underpays15166112underpays
underplays1644652underplays
underran948422underran
undertax1646112undertax
angerly1137773angerl_y
delay94820633__de_lay
deray95024183__der_ay
elderly1154943elderl_y
endplay13103963end_play
innerly1037133innerl_y
interlap1048593interlap
interlays1248083interlays
interplay1447163interplay
nudely10299033nude_l_y
orderly1135763orderl_y
overlay132410833_overlay
roundelay1342723rounde_lay
superlay1347743superlay
tenderly1245293tenderl_y
undead82711903unde__ad
under64624213under___
underact11311513underact
underage101012273underage
underarm1147843underarm
underate9918603underate
underbake1647173underbake
underbelly1643513underbelly
underbid12108203underbid
underbody1644723underbody
underbud12136213underbud
underbuys15134703underbuys
undercard1347003undercard
underclass1344883underclass
undercoat1248733undercoat
undercut1148663undercut
underdid11128133underdid
underdo937363under_do
underdog1145353underdog
undereats10310223undereats
underfed13311713underfed
underflow1643943underflow
underfur1245093underfur
underglaze2144203underglaze
undergo937043under_go
undergod1136583undergod
undergrad1245483undergrad
underhair1345733underhair
underhand1447263underhand
underheat1348383underheat
underjaws2044473underjaws
underlaying16125763underlaying
underlets10158893underlets
underlies101414203underlies
underline101714673underline
underling111514613underling
underlips12147673underlips
underloads1245233underloads
underpaid1346963underpaid
underpart1288513underpart
underpass12136783underpass
underpin1138843underpin
underplayed1875023underplayed
underplot1246823underplot
underrate10411893underrate
underrun986813underrun
undersea9149883undersea
underseas1087803underseas
underset91417133underset
undertake1448273undertake
undertow1266233undertow
underuse939753underuse
underwear1344763underwear
undraw1037813und_r_aw
undular837123und_ular
unduly1037823und_ul_y
unlay84613703un___lay
unmerry1245023unmer_ry
unorderly1342963unorderl_y
unreally1148223unreally
utterly1035443utterl_y

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.1561145455.1
2DLD Change Limit1461621018.17017890.1
3Display Results1011010.0502020.0
 (SQL Overall)1786911018.37621333.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.