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

136 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
dunelike133530(None) 
runelike1236031runelike
auntlike1234982auntlike
domelike15177752domelike
dovelike16157132dovelike
dustlike1335362dustlike
fumelike1735222fumelike
fuselike1535672fuselike
jutelike1935332jutelike
linelike12159002linelike
nunlike11258072nun_like
pinelike14188612pinelike
sunlike112310572sun_like
tubelike1436092tubelike
unalike11311532_unalike
unlike102614062_un_like
adobelike1642503adobelike
adultlike1441943adultlike
aguelike1344673aguelike
antlike11312073_antlike
apelike13310533_apelike
beelike13379783_beelike
belike124616283__belike
budlike14257873bu_dlike
buntline10198063buntline
bushlike1734963bushlike
cagelike1537723cagelike
cavelike1738213cavelike
cokelike1336813cokelike
cultlike1434933cultlike
cuplike1537213cu_plike
dateline9810353dateline
dawnlike1634673dawnlike
deerlike1335723deerlike
delime9314043d__elime
dirgelike1543213dirgelike
disclike15208653disclike
dishlike16287893dishlike
disklike12206743disklike
dislike122913453d_islike
doglike13207453d_oglike
doughlike1842683doughlike
downlike1636183downlike
drumlike1543793drumlike
dualize1759763du_alize
dueling93614543du_eling
duelist8511413du_elist
duneland1043343duneland
dunite7315013dun__ite
dunlin739723dun_li_n
dunlins849553dun_lins
dunnite857333dun_nite
duvetine1245163duvetine
eyelike1436973_eyelike
fanglike1636823fanglike
fanlike142610503fan_like
faunlike1534763faun_like
finlike14279063fin_like
flutelike1663583flutelike
fuguelike1742083fuguelike
gamelike1538033gamelike
gatelike1337933gatelike
gauzelike2342603gauzelike
glenlike1334043glenlike
gluelike1335023gluelike
gonglike1455423gonglike
gulflike1643453gulflike
gumlike14317403gu_mlike
gutlike12308653gu_tlike
handlike1639153handlike
harelike1539613harelike
henlike1448693hen_like
hoelike141411163_hoelike
homelike17179533homelike
hoselike15179643hoselike
husklike1433613husklike
hutlike14349063hu_tlike
icelike1337173_icelike
inklike1037033_inklike
jadelike2035993jadelike
junglelike2251283junglelike
kinglike1235093kinglike
kitelike1135733kitelike
lacelike1438493lacelike
lakelike1137383lakelike
lifelike15166223lifelike
manlike133012783man_like
mazelike2336463mazelike
mouselike1545013mouselike
netlike11308913__netlike
nonelite8313613nonelite
noselike12158573noselike
nutlike113110113nu_tlike
ovenlike1535013ovenlike
pipelike16166693pipelike
popelike16177853popelike
pumplike1834373pumplike
purselike1544373purselike
puslike1347563pu_slike
pusslike1434033pusslike
quaylike2434143quaylike
ringlike1336243ringlike
ropelike14157853ropelike
roselike12169183roselike
rubylike1753353rubylike
rufflike1843253rufflike
ruglike1236283ru_glike
rushlike1534333rushlike
sandlike1339713sandlike
songlike1336523songlike
sonlike112110713son_like
spinelike1585353spinelike
suchlike1735123suchlike
suitlike1236313suitlike
surflike1535933surflike
tanklike1136013tanklike
tapelike1437493tapelike
tentlike1236903tentlike
tidelike1336743tidelike
tilelike1237053tilelike
tinlike11248803tin_like
toelike11149823_toelike
treelike1237003treelike
tublike1337083tu_blike
tunnellike1451773tunnellike
turflike1534443turflike
tusklike1133583tusklike
unliked122411283_un_liked
unlive92712333_un_live
urnlike1136713_urnlike
vaselike1536993vaselike
viselike1536923viselike
wavelike1836613wavelike
wifelike18135253wifelike
winglike1635593winglike
wirelike15167493wirelike

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 Limit1461621367.14320462.3
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.60923484.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.