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 “underside” 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
underside1131014(None) 
undersides1248691undersides
undersize1949511undersize
underbid12108202underbid_
underbids13137242underbids
underbite1249812underbite
underdid11128132underdid_
underlie91413122underli_e
underline101714672underline
undermine122012232undermine
underripe1247832underripe
undersign1177112undersign
undersized2148212undersized
underwire1348122underwire
andesite949453ande_site
depside1138403__depside
deride84420033__der_ide
endorsive1344213endorsive
inversive1557193inversive
nearside944913_nearside
overside122013933_overside
riverside1344913riverside
undeceive1544773undeceive
undecided1445983unde_cided
undenied102211563unde_nied
underage101012273under_age
underaged121011233underaged
underate9918603under_ate
underbake1647173underbake
underbidder1652513underbidder
underbites1347893underbites
underbody1644723underbody
underbred1338993underbred
underbud12136213underbud_
underbuds13145593underbuds
underdo937363under__do
underdone1158213underdone
underdose1157593underdose
underfed13311713underfed_
underfeed1448633underfeed
undergird1245903undergird
undergirded1544013undergirded
undergirds1344453undergirds
undergirt1147813undergirt
undergod1136583undergod_
undergods1246333undergods
undergone1158273undergone
underived14310513under_ived
underkill1445073underkill
underlaid1147493underlaid_
underlies101414203underlies
underlined121610213underlined
underlines111512113underlines
underling111514613underling
underlip11157203underli_p
underlips12147673underlips
underlit91311533underli_t
undermined14189133undermined
undermines131710663undermines
underpaid1346963underpaid_
underpin1138843underpi_n
underpins1239733underpins
underprice1545513underprice
underrate10411893underrate
underscore1345803underscore
undersea9149883unders_ea
underseas1087803underseas
undersell1045763undersell
underset91417133unders_et
undersets10129323undersets
undersexed1946083undersexed
undershirt1446453undershirt
undershot1346893undershot
undersigned14114973undersigned
undersigns1265833undersigns
underskirt1545023underskirt
undersoil1056773undersoil
undersoils1156063undersoils
undersold1146883undersold
undersong1147993undersong
underspin1246653underspin
underspins1346833underspins
understate1148863understate
understeer1145813understeer
understudy1543183understudy
undertake1448273undertake
undertint10414863undertint
undertone10510203undertone
underuse939753under_use
underused1139333underused_
underusing1247263underusing
undervote1357753undervote
underwing141410883underwing
underwires1447023underwires
underwrite1446313underwrite
undesired1147523unde_sired
undressed1138343undressed
undried92314613und_r_ied
unfertile1246413unfertile
unversed122310433unversed_
waterside1345803waterside

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.1561145455.1
2DLD Change Limit1486411016.97021325.8
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.17224915.1
 
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.