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

177 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
minnows123491(None) 
minnow1135581minnow_
winnows1334531winnows
indows104210792_indows
miaows1145472mi_aows
mignons1037862mignons
minions93314622minions
minnies93617362minnies
minors85117092mi_nors
misknows1743062misknows
windows1447742windows
winnow1234592winnow_
annoys967523_annoys
besnows1245153besnows
billows123611283billows
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bi_nocs
cannons94412883cannons
cineols9128853cineols
dingoes94114833dingoes
dinners83915443dinners
dinos65428063di_no_s
endows104610423_endows
enows85115493__enows
finos86226953fi_no_s
ginners84314223ginners
ginzoes1735433ginzoes
hinnies103615103hinnies
incogs937903_incogs
indols74714203_indols
indow95011663_indow_
inflows1335523_inflows
infos84311673_info_s
ingots7912063_ingots
inions64417003_inions
inners63919353_inners
inns46920933_inn__s
intown936153_intown
jingoes153811443jingoes
jinnis13489053jinn_is
jinns126013843jinn__s
kinos96626143ki_no_s
knows124912413__knows
lingoes84014693lingoes
linnets739833linnets
linns56123333linn__s
linos55631503li_no_s
lintols7339553lintols
maintops1244403maintops
mallows123714323mallows
mangoes104316133mangoes
mangos94319333mango_s
maniocs113611443maniocs
mannans93611523mannans
mannas85019803mann_as
manners93417833manners
mannose939243mannose
mannoses1039083mannoses
manors84420883m_anors
manos74933613m_ano_s
marrows122911813marrows
meadows1337333meadows
mellows123812233mellows
mentors9314993mentors
meows104612683m__eows
miaous8511693mi_aous
miaow1058353mi_aow_
microns113814783microns
micros104115363micro_s
midnoon1044683midnoon
midnoons1144403midnoons
midtown1343673midtown
midtowns1443243midtowns
miens76118303mien__s
mignon937953migno_n
mikrons13428413mikrons
mikvos1554023mikvo_s
mildews13365883mildews
milnebs11113793milnebs
milos75428013mi_lo_s
mimeos104511543mimeo_s
minas75434113mi_n_as
mincers113714843mincers
minces104420803mi_nces
minders103720113minders
minds85427123mi_n_ds
miners84126633mi_ners
mines75651953mi_n_es
mingles103719003mingles
minibus1136333minibus
minims104514813mi_nims
minings103912073minings
minion83416243minio_n
minis75432993mi_n_is
miniums113910213miniums
minkes124618783mi_nkes
minks115829273mi_n_ks
minny104518663minn__y
minor74920063mi_no_r
minters93822463minters
mints76834043mi_n_ts
minuets9259853minuets
minus75223933mi_n_us
minuses93512703minuses
minutes93513433minutes
minxes154612983mi_nxes
minyans1237263minyans
mirrors938623mirrors
misdoes10312493misdoes
misgrows1444963misgrows
misknow1643213misknow_
misknown1742533misknown
misos76523293mi_so_s
mistbows1543993mistbows
mondos95217333mondo_s
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monos75930863m_ono_s
moonbows1543953moonbows
morrows12318723morrows
mows96340833m___ows
mungoes103510463mungoes
mungos94311373mungo_s
munnions1035273munnions
ninnies73713613ninnies
ninons64913773ni_nons
nonnews1035313nonnews
nows75738233___nows
ominous949023omi_nous
pennons939713pennons
pianos84315933piano_s
pillows122610103pillows
pingoes105116523pingoes
pingos95317673pingo_s
pinions93413603pinions
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinnas85315513pinn_as
pinners93518603pinners
pinnies93318443pinnies
pinones94717073pinones
pinons86019943pi_nons
pinots85920273pi_nots
pintoes95117713pintoes
pintos86021293pinto_s
pinyons12299003pinyons
rainbows1343243rainbows
sannops936693sannops
signors83410903signors
sinews94210623si_news
sinners74019023sinners
sinuous739063sinuous
snows84719883__snows
sunbows1236023sunbows
tannoys1055553tannoys
tinners73717313tinners
topminnows175483topminnows
vinos84723073vi_no_s
vinous93914173vi_nous
widows1376563wi_dows
willows13299743willows
window1347363window_
windowy1744643windowy
windrows1546163windrows
wingbows1743983wingbows
winners104316913winners
winnock1643893winnock
winnocks1743873winnocks
winnowed1543463winnowed
winnower1444253winnower
winnowers1543953winnowers
winoes94317013wi_noes
winos84625043wi_no_s
zincous1837053zincous
zinnias1635863zinnias

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271776.32621186.7
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.54527301.9
 
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.