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

256 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
tannish10161057(None) 
mannish121710691mannish
tarnish101611871tarnish
tonnish10149091tonnish
banish111416042ba_nish
clannish1345262clannish
danish101513792da_nish
donnish11187632donnish
garnish111610842garnish
hennish1336862hennish
hunnish1336162hunnish
nannyish1443302nannyish
nunnish1035932nunnish
panfish15229972panfish
rankish14510382rankish
standish1238542standish
tallish103313582tallish
tanist6324592ta_nist
tannest72617852tannest
tannic82811472tanni_c
tannin62613922tanni_n
tanning83618252tanning
tannins72813222tannins
tartish101512632tartish
tennis64015302tennis_
tennist72813112tennist
thinnish1454872thinnish
tonish93415902t_onish
townish13167932townish
tundish1137282tundish
vanish121513212va_nish
varnish13169532varnish
wennish1336242wennish
zanyish2235902zanyish
aguish1059283_aguish
anguish11117633_anguish
anis45746463_a_nis_
anise55129703_a_nise
ankush13114433_ankush
annas55824883_annas_
antis55033313_antis_
apish105116633_a_pish
aspish114810333_aspish
babyish1736513babyish
bairnish1345473bairnish
baldish1339503baldish
banning103818233banning
banns75321233bann_s_
batfish1558683batfish
bennis84314803bennis_
blandish1497003blandish
brainish1338813brainish
brandish1469023brandish
brinish1239963brinish
burnish1238623burnish
caddish143810123caddish
cannas84518403cannas_
cannie83819363canni_e
cannier94014163cannier
canniest10313363canniest
cannily1239263cannily
canning103620133canning
canonise10511093canonise
canonist10513533canonist
carlish12312763carlish
catfish1559023catfish
cattish12410723cattish
crankish1736513crankish
cronish12310863cronish
dampish1567663dampish
dandyish1644723dandyish
darkish1537943darkish
dronish1138913dronish
duncish1335793duncish
evanish1337653evanish
faddish15359003faddish
faintish1446193faintish
fairish1338993fairish
famish14311843fa_mish
fannies103415643fannies
fanning113615073fanning
fanwise1336633fanwise
fattish1359263fattish
finfish16268193finfish
finish124613413_finish
furnish1337383furnish
garfish14179203garfish
garish104516923ga_rish
gawkish1835833gawkish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hawkish2036553hawkish
jadish17319903ja_dish
jinnis13489053jinnis_
kaddish16317973kaddish
kanjis1735963kanjis_
knavish1743993knavish
knish1238603__knish
laddish12299723laddish
ladyish14287823ladyish
lanais6316793lanais_
languish12136253languish
largish1138603largish
larkish1439083larkish
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
longish11229093longish
maddish14289483maddish
maidish13239553maidish
mannas85019803mannas_
manning103616383manning
mannishly1744113mannishly
mannite9312903mannite
mannose939243mannose
mantis83926033mantis_
manwise1239183manwise
marish114319053ma_rish
mawkish1935823mawkish
minish115216303_minish
minxish1936213minxish
monish114217593_monish
monkish1638243monkish
moonish123311043moonish
nanism8311203na_nism
nannie63713223nanni_e
nannies73015203nannies
ninnyish1442843ninnyish
oafish121311723oa_fish
oarfish13158613oarfish
onanism9310133onanism
onanist7314633onanist
orangish1246553orangish
paganish1447773paganish
palish114718273pa_lish
pannes85522853pannes_
pannier93613353pannier
panning104019393panning
parish115022353pa_rish
pennis84315743pennis_
pinfish15319303pinfish
pinkish16279113pinkish
planish12412053planish
plenish1239943plenish
prankish1737023prankish
punish111411503_punish
punkish16257693punkish
radish103516913ra_dish
raffish1658843raffish
rakish134313963ra_kish
rammish1437563rammish
ranis55235833ra_nis_
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
runtish1048693runtish
saltish10312163saltish
sandfish1556683sandfish
sawfish1637683sawfish
stablish1348343stablish
stannic936663stanni_c
stannite847583stannite
starfish1438083starfish
stonish10410653stonish
sunfish1338883sunfish
swainish1444753swainish
swinish1347203swinish
tabbis102910863tabbis_
tachism1478873tachism
tachist12613293tachist
taenia6313193taeni_a
taeniae739083taeniae
taenias7311283taenias
tahinis1048013tahinis_
tains54936323tain_s_
taints64520533taints_
takins105117403takins_
tallis63319963tallis_
tallith102913063tallith
tamis76728733ta_mis_
tangier83013903tangier
tangiest92915223tangiest
tanging93419523tanging
tangos74216303tangos_
tangs65028343ta_ngs_
tanists7313653ta_nists
tankas104613763tankas_
tanking123918793tanking
tankini11338923tankini
tankinis12245913tankinis_
tanks94624733ta_nks_
tannage8209583tannage
tannate71813523tannate
tanned75219953tann_ed
tanner63722283tann_er
tanners74018393tanners
tannery10388663tannery
tannings9268633tannings
tannoy958353tann_oy
tannoys1055553tannoys
tans46154823ta_n_s_
tansies74521243tansies
tansy84514933ta_n_sy
tantivy1335563tantivy
tantrism1048373tantrism
tanukis1134713tanukis_
tapis75028863ta_pis_
tarbush1234173tarbush
tarnished13196063tarnished
tarnishes12188893tarnishes
tarns56433953tarn_s_
taunts65715663taunts_
tawnier10318463tawnier
tawnies102812503tawnies
tawniest11279343tawniest
tawnily1335443tawnily
taxis126821973ta_xis_
taxwise1734253taxwise
tennies73017973tennies
tennises82810133tennises
tennists8297793tennists
tenuis64213083tenuis_
tigrish1137573tigrish
tinnier72910143tinnier
tinniest82911463tinniest
tinnily1047363tinnily
tinning83117283tinning
toadfish1544903toadfish
toadish1139063toadish
toadyish1544153toadyish
tonnes65320853tonnes_
toyish122911123t_oyish
trampish1535653trampish
trannies8415013trannies
tunnies73614263tunnies
tunning83514453tunning
tyrannise1253713tyrannise
unmannish1443363unmannish
unwish1239093_unwish
vampish1766283vampish
vanning113912463vanning
vanquish2343543vanquish
varnishy17163403varnishy
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
wanness102610683wanness
wannest103915003wannest
wanning113816213wanning
warmish1538373warmish
waspish1586923waspish
winish124212263_winish

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.406440125.6
2DLD Change Limit1340272566.03022226.7
3Display Results2562560.0962666.7
 (SQL Overall)1786912566.53227356.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.