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

140 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
milked13461257(None) 
bilked134012941bilked
miked125020451mi_ked
milded104416151milded
milker124814321milker
milled94326171milled
milted93919941milted
silked114314811silked
ailed66240282ail_ed
balked135219412balked
biked125320032bi_ked
bilged105513182bilged
bilker124913442bilker
billed94224902billed
bulked134216742bulked
calked134617402calked
dicked144920862dicked
diked115024682di_ked
dilled84122222dilled
dinked124818352dinked
dirked124912272dirked
disked125015762disked
filed95331902fil_ed
filled104922262filled
filmed124610362filmed
finked144214622finked
gilded94413222gilded
gilled84521632gilled
hiked135919202hi_ked
hilled104022222hilled
hilted104016042hilted
holked144913662holked
hulked144611302hulked
inked104218522_inked
irked104510922_irked
jilted144111352jilted
jinked184013142jinked
kicked124415942kicked
killed113918772killed
kilned11368392kilned
kilted113613832kilted
kinked104014752kinked
licked134621562licked
liked104523812li_ked
lilied73913212lilied
lilted73715372lilted
linked114518212linked
mailed95326752mail_ed
malfed12369752malfed
malled94626102malled
malted94819852malted
marked133921622marked
masked134316522masked
melded104714712melded
melled95023022melled
melted94219062melted
miched143913392miched
mickey174211852mickey
miffed15398712miffed
mike105535292mi_ke_
mikes115129892mi_kes
mild75330852mil__d
milden94113152milden
milder93818452milder
mildew12319042mildew
mile66352572mil_e_
miler75733062mil_er
miles74645072mil_es
milieu8314112milieu
milk105028472milk__
milkers134411612milkers
milkier133411162milkier
milkmen1565212milkmen
milks115020582milk_s
milkshed1842942milkshed
milkweed1843352milkweed
milky144014442milk_y
mille75029132mille_
miller84625412miller
milles84526562milles
millet84030742millet
milneb1095952milneb
milord999562milord
milter84921232milter
mimed105622732mi_med
minced114114912minced
minded103817832minded
mined85333352mi_ned
minke115421762minke_
minkes124618782minkes
minted94220582minted
mired85729222mi_red
mirker123712692mirker
misfed124113022misfed
misled94719312misled
misliked15319512misliked
missed94423602missed
misted93625822misted
mitred94414342mitred
mixed155717252mi_xed
mocked154716612mocked
moiled94318862moil_ed
molded104414082molded
molted94217472molted
mucked153816092mucked
muled85824432mul_ed
mulled94721552mulled
nicked135019682nicked
nilled73919452nilled
oiled64429472oil_ed
oinked114213282oinked
picked154421312picked
piked125623312pi_ked
piled85232992pil_ed
pilled94222752pilled
pinked134819882pinked
ricked136523622ricked
riled65833252ril_ed
rilled74525652rilled
risked115514632risked
sicked134524402sicked
silken104410852silken
siloed74615302siloed
silted74020012silted
smiled93716432smil_ed
smirked14307232smirked
sulked114314702sulked
talked114015402talked
ticked134720522ticked
tiled64832942til_ed
tilled74722952tilled
tilted74616862tilted
walked145313782walked
wicked164317412wicked
wilded113714502wilded
wiled95231552wil_ed
willed104722452willed
wilted103915712wilted
winked144018602winked
yolked14367152yolked

Search took 4 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.1101624463.6
2DLD Change Limit825511402.90328436.4
3Display Results1401400.0463043.5
 (SQL Overall)1786911403.05958414.8
 
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.