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

190 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
sunfish133888(None) 
duncish1335792duncish
finfish16268192finfish
huffish1935712huffish
hunnish1336162hunnish
lungfish1543962lungfish
mudfish1646262mudfish
nunnish1035932nunnish
outfish132210572outfish
panfish15229972panfish
pinfish15319302pinfish
punish111411502pun_ish
punkish16257692punkish
pupfish1735532pupfish
runtish1048692runtish
sandfish1556682sandfish
sawfish1637682sawfish
selfish1388512selfish
serfish1348972serfish
studfish1544522studfish
suckfish2043892suckfish
sunfast1038502sunfast
sunfishes1547032sunfishes
sunrise7310812sunrise
sunwise1036432sunwise
surffish1744782surffish
tundish1137282tundish
unwish1239092_unwish
banish111416043ban_ish
batfish1558683batfish
bluefish1645143bluefish
bonefish1646283bonefish
boxfish2285543boxfish
buckish18237883buckish
bullish12511193bullish
bundist10310193bundist
burnish1238623burnish
catfish1559023catfish
codfish1637163codfish
cowfish1836433cowfish
cubbish1635803cubbish
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
danish101513793dan_ish
deafish1438533deafish
dogfish15226763dogfish
donnish11187633donnish
drumfish1743503drumfish
dudish1148313du_dish
dullish1148743dullish
dumpish15116113dumpish
duskish1535183duskish
elfish1267963_elfish
finish124613413fin_ish
fish106926273___fish
foxfish2354483foxfish
funfest13348083funfest
furbish1536443furbish
furnish1337383furnish
garfish14179203garfish
gruffish1843943gruffish
gunfight1643493gunfight
gunfire1134743gunfire
hagfish17227613hagfish
hennish1336863hennish
hogfish17257023hogfish
jewfish2343543jewfish
kingfish1944493kingfish
knish1238603_kn_ish
kufis1249253ku_fis_
lionfish1454093lionfish
longish11229093longish
lumpfish1843053lumpfish
lumpish14127383lumpish
lungis77113023lungis_
lutfisk1443583lutfisk
mannish121710693mannish
minish115216303min_ish
minxish1936213minxish
monish114217593mon_ish
monkfish2044003monkfish
monkish1638243monkish
moonfish1675333moonfish
mulish11311903mu_lish
munis75022003mun_is_
numbfish1842603numbfish
oafish121311723_oafish
oarfish13158613oarfish
offish15137273_offish
outwish13289853outwish
pigfish16217173pigfish
pinkish16279113pinkish
publish1447913publish
puckish18237213puckish
puggish14265993puggish
punjis1536693punjis_
raffish1658843raffish
rankish14510383rankish
ratfish1338773ratfish
redfish1437793redfish
roundish1246253roundish
rubbish1436303rubbish
ruttish1048303ruttish
sailfish1446053sailfish
saltish10312163saltish
sickish1638423sickish
slavish1338233slavish
slowish1337633slowish
sluggish1344773sluggish
sluttish1145443sluttish
snash84815673s_n_ash
sneesh945893s_neesh
sniffish1744513sniffish
snuffs12358533snuffs_
softish13127813softish
sottish10129443sottish
sourish10310693sourish
squarish2047323squarish
squawfish2742263squawfish
squirish2045113squirish
squish1838573s_quish
standish1238543standish
starfish1438083starfish
stiffish1745243stiffish
stonefish1544063stonefish
stonish10410653stonish
stylish13197443stylish
subfile122010503subfile
subfix1835073subfi_x
subfusc1444333subfusc
submiss1138083submiss
subsist9311573subsist
suffice15197573suffice
suffix1935233suffi_x
suffuse1335443suffuse
sulfas9311563sulfas_
sulfid1039063sulfi_d
sulfide1138103sulfide
sulfids1137293sulfids
sulfite10310473sulfite
sumoist9311613sumoist
sunbath1236423sunbath
sunbird1044743sunbird
sundial859863sundial
sunless73013693sunless
sunlight1245963sunlight
sunlike112310573sunlike
sunlit61516103sunli_t
sunnah9369353sun_nah
sunnahs10326593sunnahs
sunnas63914563sunnas_
sunnier73412153sunnier
sunniest82712913sunniest
sunnily1037833sunnily
sunning83715673sunning
sunns55017353sun_ns_
sunrises8310693sunrises
suns45841903sun__s_
sunups837263sunups_
surfier102613543surfier
surfiest112414433surfiest
surfing112914483surfing
surfs85022543surf_s_
surmise9311083surmise
sushis9311183sushis_
swinish1347203swinish
swish115114823s__wish
tannish101610573tannish
tonish93415903ton_ish
tonnish10149093tonnish
trunkfish1941723trunkfish
unais53420773_unais_
unfaith1345783_unfaith
unfished15218293_unfished
unfit84518563_unfi_t
unfits93910293_unfits
unfix15429033_unfi_x
unfixt16398423_unfixt
unlash938793_unlash
unmesh1145793_unmesh
unwise9510803_unwise
uppish1336633_uppish
vanish121513213van_ish
waifish1637703waifish
wennish1336243wennish
winish124212263win_ish
wolfish1636933wolfish
youngish1543633youngish
zanyish2235903zanyish

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.423422437.4
2DLD Change Limit1340271907.51617832.2
3Display Results1901900.0762500.0
 (SQL Overall)1786911908.01522294.6
 
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.