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 “underdid” 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
underdid1112813(None) 
underbid12108201underbid
underbids13137242underbids
underbud12136212underbud
underdo937362underd_o
underdog1145352underdog
underfed13311712underfed
undergird1245902undergird
undergod1136582undergod
underlaid1147492underlaid
underlie91413122underlie
underlip11157202underlip
underlit91311532underlit
underpaid1346962underpaid
underpin1138842underpin
underside11310142underside
android9311513and_roid
aneroid8314013an_eroid
endermic1356173endermic
energid948303en_ergid
nereid7312933_n_ereid
overdid12199173_overdid
sundered10312153sunder_ed
unafraid1242663unafraid
unbearded13146343unbearded
unbended12279973unbended
unbraid1037183un_braid
uncandid1244603uncandid
uncarded12310133uncarded
unceded11410563unce_ded
undead82711903unde__ad
undecided1445983undecided
undecked16238493undecked
undeluded1244363undeluded
undenied102211563undenied
undented102313953undented
under64624213under___
underact11311513underact
underage101012273underage
underaged121011243underaged
underarm1147843underarm
underate9918603underate
underbite1249813underbite
underbody1644723underbody
underbred1338993underbred
underbrim1444633underbrim
underbuds13145593underbuds
underbuy14125383underbuy
undercard1347003undercard
underclad1345563underclad
undercut1148663undercut
underdoes1139103underdoes
underdogs1245753underdogs
underdoing1346803underdoing
underdone1158213underdone
underdose1157593underdose
underdosed1346163underdosed
undereat9313903undereat
underfeed1448633underfeed
underfund1445373underfund
underfur1245093underfur
undergirds1344453undergirds
undergirt1147813undergirt
undergo937043under_go
undergods1246333undergods
undergrad1245483undergrad
underhair1345733underhair
underhand1447263underhand
underived14310513underived
underjaw1943993underjaw
underkill1445073underkill
underlain1048683underlain
underlap11146423underlap
underlay12147653underlay
underlet91516213underlet
underlies101414203underlies
underline101714673underline
underlined121610213underlined
underling111514613underling
underlips12147673underlips
underload1146373underload
undermine122012233undermine
undermined14189133undermined
underpay14136213underpay
underpins1239733underpins
underran948423underran
underripe1247833underripe
underrun986813underrun
undersea9149883undersea
underset91417133underset
undersides1248693undersides
undersign1177113undersign
undersize1949513undersize
undersized2148223undersized
undersoil1056773undersoil
undersold1146883undersold
underspin1246653underspin
undertax1646113undertax
undertint10414863undertint
undertow1266233undertow
underuse939753underuse
underused1139333underused
underway15136343underway
underwing141410883underwing
underwire1348123underwire
underwood1446473underwood
undid72415363un___did
undried92314613und_ried
unended92811823un_ended
ungelded1147403ungelded
ungirded1136083ungirded
unheeded1336893unheeded
unheroic1345263unheroic
unleaded10411333unleaded
unmended12299093unmended
unneeded1036483unneeded
unnerved1248063unnerved
unrepaid1143713unrepaid
unseeded1038253unseeded
unserved12410233unserved
untended102611153untended
unversed122310443unversed
unwedded1435403unwedded
unweeded1336573unweeded
unwelded1337143unwelded
wunderkind1942733wunderkind

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.420425454.8
2DLD Change Limit1461621267.20320291.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.66923300.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.