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

225 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
pinkish1627911(None) 
pinfish15319301pinfish
punkish16257691punkish
finfish16268192finfish
finish124613402fin_ish
hickish1936472hickish
minish115216292min_ish
minxish1936212minxish
monkish1638242monkish
panfish15229972panfish
peakish16268872peakish
peckish18227292peckish
perkish16258822perkish
pigfish16217172pigfish
piggish14227702piggish
pikis115116392pi_kis_
pinkest132812622pinkest
pinkie124414272pinki_e
pinkies133818262pinkies
pinking143918942pinking
pinkos125313872pinkos_
pinks115729382pink_s_
pixyish2253652pixyish
prankish1737022prankish
puckish18237212puckish
punish111411502pun_ish
rankish14510382rankish
sickish1638422sickish
winish124212262win_ish
ankush13114433_ankush
banish111416043ban_ish
biggish14247503biggish
bindis94614583bindis_
bookish163610023bookish
brinish1239963brin_ish
buckish18237883buckish
cockish1838503cockish
crankish1736513crankish
danish101513793dan_ish
darkish1537943darkish
dinkier123411503dinkier
dinkies123716033dinkies
dinkiest133812873dinkiest
dinking133618283dinking
dinks105927953dink_s_
donnish11187633donnish
duncish1335793duncish
duskish1535183duskish
faintish1446193faintish
fiendish1544033fiendish
finis86824263fin_is_
finking154016603finking
finks125424223fink_s_
folkish1736563folkish
gawkish1835833gawkish
ginks104319563gink_s_
girlish1137193girlish
hawkish2036553hawkish
hennish1336863hennish
hinkier143610793hinkier
hinkiest153311753hinkiest
hippish1736183hippish
hunnish1336163hunnish
impish13499173_impish
incise83515323_incise
inkier104013773_inkier
inkiest113415043_inkiest
inking115119043_inking
inks86926503_ink_s_
inmesh1134853_inmesh
inrush936513_inrush
insist6314503_insist
intis55121633_intis_
jiggish19225943jiggish
jingoish19134373jingoish
jinking193613543jinking
jinks165019333jink_s_
jinnis13489053jinnis_
kiddish16276583kiddish
kingfish1944483kingfish
kinkier10319433kinkier
kinkiest113110503kinkiest
kinkily1335223kinkily
kinking113615153kinking
kinks84926083kink_s_
knish1238603_kn_ish
larkish1439083larkish
linking123818253linking
links96430193link_s_
lionfish1454093lionfish
longish11229093longish
mannish121710693mannish
mawkish1935823mawkish
milkfish2043333milkfish
minis75432983min_is_
minkes124618783minkes_
minks115829273mink_s_
monish114217593mon_ish
monkfish2044003monkfish
ninnyish1442843ninnyish
nunnish1035933nunnish
oinking123714713oinking
oinks94819913oink_s_
palish114718273p_alish
parish115022353p_arish
peevish1535783peevish
penis75129323pen_is_
pennis84315743pennis_
perish114619063p_erish
pettish1238283pettish
pianism11611033pianism
pianist9615103pianist
pickier153912973pickier
pickiest162712593pickiest
picking163418333picking
picks135226143pick_s_
pietism1139113pietism
pietist9414033pietist
pikas114218093pi_kas_
pikes115031033pi_kes_
piki106520563pi_ki__
piking133719643pi_king
pilis75825203pi_lis_
pinas75434453pin_as_
pinch125619303pin__ch
pines76048863pin_es_
pinfishes1746243pinfishes
pinging113419553pinging
pingos95317673pingos_
pings85830883pin_gs_
pinier84024693pin_ier
piniest93121133piniest
pining93726533pin_ing
pinion83815893pin_ion
pinite8321243pin_ite
pink107039383pink___
pinked134819883pink_ed
pinken124513283pink_en
pinkens13419643pinkens
pinker125322443pink_er
pinkers134118603pinkers
pinkey154314673pink_ey
pinkeye16326493pinkeye
pinkeys16378213pinkeys
pinkings15338143pinkings
pinkly155012243pink_ly
pinkness1436513pinkness
pinko115618253pink__o
pinkoes135512313pinkoes
pinky145823403pink__y
pinnas85315513pinnas_
pinnies93318443pinnies
pinning103417853pinning
pinons86019943pinons_
pinots85920273pinots_
pins65558453pin__s_
pintas85021393pintas_
pintos86021293pintos_
pints75936223pin_ts_
pinups1037413pinups_
pinyin112710613pinyi_n
pipefish1844533pipefish
pipkin14248603pipki_n
pipkins15328183pipkins
pish96127913p___ish
pixieish2042603pixieish
planish12412053planish
plenish1239943plenish
plinking153611243plinking
plinks124913263plink_s_
polish114916723p_olish
poorish123712303poorish
popish133812113p_opish
priggish1544683priggish
prinking153212453prinking
prinks124315383prink_s_
prudish1376563prudish
publish1447913publish
puggish14265993puggish
punjis1536693punjis_
punkah15347093punk_ah
punkahs16284783punkahs
punkas123410673punkas_
punkest132611693punkest
punkie123513613punki_e
punkier133512793punkier
punkies134216803punkies
punkiest149312663punkiest
punkin123611523punki_n
punkins133111113punkins
punks114822683punk_s_
pupfish1735533pupfish
quirkish2442993quirkish
rakish134313963_rakish
rikisha1442343ri_kisha
rinks94827103rink_s_
runtish1048693runtish
sinking123320543sinking
sinks95529183sink_s_
sparkish17276973sparkish
spookish1744643spookish
sunfish1338883sunfish
swinish1347203swin_ish
tannish101610573tannish
thickish2044593thickish
thinnish1454863thinnish
ticklish1755283ticklish
tigrish1137563tigrish
tikis95615973ti_kis_
tonish93415903ton_ish
tonnish10149093tonnish
trickish1746793trickish
tundish1137283tundish
unwish1239093_unwish
vanish121513203van_ish
weakish17217173weakish
wennish1336243wennish
widish13419363wi_dish
wildish1446853wildish
wimpish1765683wimpish
winking153317963winking
winks125325433wink_s_
wispish1575643wispish
zanyish2235903zanyish
zinkify2643123zinkify

Search took 9 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.1401276364.3
2DLD Change Limit1340272257.79617191.8
3Display Results2252250.0802812.5
 (SQL Overall)1786912258.01622291.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.