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 “milded” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
milded10441615(None) 
gilded94413221gilded
melded104714711melded
milden94113151milden
milder93818451milder
mildew12319041mildew
milked134612571milked
milled94326171milled
milted93919941milted
minded103817831minded
molded104414081molded
wilded113714501wilded
aided75828932ai_ded
ailed66240282ail_ed
balded105417512balded
bided95424962bi_ded
bielded11226712bielded
bilged105513182bilged
bilked134012942bilked
billed94224902billed
birded104414302birded
builded1136472builded
dilled84122222dilled
elided84814672elided
fielded12206812fielded
filed95331902fil_ed
filled104922262filled
filmed124610362filmed
folded114212792folded
gelded94512112gelded
gilder84415532gilder
gilled84521632gilled
girded93712492girded
glided94513902glided
hided105222442hi_ded
hilled104022222hilled
hilted104016042hilted
idled74915212_idled
jilted144111352jilted
kidded13299392kidded
killed113918772killed
kilned11368392kilned
kilted113613832kilted
lidded93410242lidded
lilied73913212lilied
lilted73715372lilted
madded113513552madded
mailed95326752mail_ed
malfed12369762malfed
malled94626112malled
malted94819862malted
melder93915812melder
melled95023022melled
melted94219062melted
mended104418682mended
miched143913392miched
midden104112852midden
middled123311902middled
midleg1038552midleg
miffed15398712miffed
miked125020452mi_ked
mild75330852mil__d
mildened1235772mildened
mildens10339932mildens
mildest102812062mildest
mildewed1543762mildewed
mildews13365882mildews
mildewy16353532mildewy
mildly12318242mildly
milds86422052mild_s
mile66352572mil_e_
miler75733062mil_er
miles74645072mil_es
milieu8314112milieu
milker124814322milker
mille75029132mille_
miller84625412miller
milles84526562milles
millet84030742millet
milneb1095952milneb
milord999572milord
milter84921232milter
mimed105622732mi_med
minced114114912minced
minder94822502minder
mined85333352mi_ned
minted94220582minted
mired85729222mi_red
misdeed113211052misdeed
misdid10510572misdid
misfed124113022misfed
misled94719312misled
missed94423602missed
misted93625822misted
mitred94414342mitred
mixed155717252mi_xed
moiled94318862moil_ed
molder93819272molder
molted94217472molted
moulded11348062moulded
mudded114511382mudded
muled85824432mul_ed
mulled94721552mulled
nided75920872ni_ded
nilled73919452nilled
oiled64429472oil_ed
piled85232992pil_ed
pilled94222752pilled
ridded93615122ridded
riled65833252ril_ed
rilled74525652rilled
rinded84418982rinded
sided74825952si_ded
sidled84215172sidled
silked114314812silked
siloed74615302siloed
silted74020012silted
smiled93716432smil_ed
tided76322512ti_ded
tilde65017342tilde_
tildes74513962tildes
tiled64832942til_ed
tilled74722952tilled
tilted74616862tilted
welded114013382welded
wielded12216682wielded
wilder103616472wilder
wiled95231552wil_ed
willed104722452willed
wilted103915712wilted
winded114918212winded
yielded12184712yielded

Search took 3 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 Filter178691825510.356501941.0
2DLD Change Limit825511322.58031996.5
3Display Results1321320.0462869.6
 (SQL Overall)1786911322.98259923.2
 
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.